Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Getting Started with Oracle Database Gateways

• 1.1 Overview
• 1.2 Oracle Heterogeneous Services
• 1.3 Oracle Database Gateways
• 1.4 Gateway Architecture
• 1.5 Gateway Process Flow
• 1.6 Setup Flow

2 Gateway Features and Restrictions

• 2.1 Accessing VSAM Data
• 2.2 SQL Support
  • 2.2.1 Transaction Support
  • 2.2.2 Pass-Through Feature
  • 2.2.3 Naming Rules
    • 2.2.3.1 Rules for Naming Objects
    • 2.2.3.2 Case Sensitivity
  • 2.2.4 Data Types
    • 2.2.4.1 Binary Literal Notation
    • 2.2.4.2 Data Type Conversion
  • 2.2.5 SQL Execution
    • 2.2.5.1 Row Selection
    • 2.2.5.2 Empty Strings
    • 2.2.5.3 Empty Bind Variables
  • 2.2.6 Locking
• 2.3 Handling Non-Relational Data
• 2.4 Restrictions
  • 2.4.1 SQL Restrictions
    • 2.4.1.1 Unsupported SQL Functions
    • 2.4.1.2 SQL Syntax
    • 2.4.1.3 Transaction Capability
    • 2.4.1.4 Transactional Integrity
    • 2.4.1.5 COMMIT or ROLLBACK in PL/SQL Cursor Loops
    • 2.4.1.6 Pass-Through Feature
    • 2.4.1.7 Database Links
    • 2.4.1.8 Data Types
    • 2.4.1.9 Encrypted Format Login
    • 2.4.1.10 Data Dictionary Views and PL/SQL
  • 2.4.2 VSAM Restrictions
    • 2.4.2.1 General VSAM Restrictions
    • 2.4.2.2 Restrictions Specific to VSAM (CICS)
    • 2.4.2.3 Restrictions Specific to VSAM Batch

3 Normalizing Non-Relational Data

• 3.1 Overview of Normalizing Non-Relational Data
• 3.2 About Arrays
• 3.3 Representing Metadata
• 3.4 Methods of Handling Arrays
  • 3.4.1 Virtual Views
  • 3.4.2 Sequential Flattening (Bulk Load of Array Data)

4 Setting the Array Handling Policy

• 4.1 Setting the Default Behavior for Array Handling
• 4.2 Modifying the Default Behavior During Metadata Import
• 4.3 Modifying the Array Handling Policy for a Specific Table

A Data Type Conversion

• A.1 Conversion of Atomic Data Types
• A.2 Conversion of Non-Atomic Data Types
• A.3 Conversion of Decimal Data Types
• A.4 Conversion of Scaled Data Types

B Supported SQL Syntax and Functions

• B.1 Supported SQL Statements
  • B.1.1 DELETE
  • B.1.2 INSERT
  • B.1.3 SELECT
  • B.1.4 UPDATE
• B.2 Oracle Functions
  • B.2.1 Functions Not Supported by VSAM
  • B.2.2 Functions Supported by VSAM
    • B.2.2.1 Arithmetic Operators
    • B.2.2.2 Comparison Operators
    • B.2.2.3 Group Functions
    • B.2.2.4 String Functions
    • B.2.2.5 Other Functions

C Data Dictionary

• C.1 Data Dictionary Support
  • C.1.1 Accessing the Gateway Data Dictionary
  • C.1.2 Supported Views and Tables
  • C.1.3 Default Column Values
• C.2 VSAM Data Dictionary Descriptions

D Globalization Support

• D.1 Character Set Terminology
• D.2 Globalization Support Settings

E Examples

• E.1 COBOL Copybook Example

Index