Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Getting Started with Oracle Database Gateways

• Overview
• Oracle Heterogeneous Services
• Oracle Database Gateways
• Gateway Architecture
• Gateway Process Flow
• Setup Flow

2 Gateway Features and Restrictions

• Accessing VSAM Data
• SQL Support
  • Transaction Support
  • Pass-Through Feature
  • Naming Rules
    • Rules for Naming Objects
    • Case Sensitivity
  • Data Types
    • Binary Literal Notation
    • Data Type Conversion
  • SQL Execution
    • Row Selection
    • Empty Strings
    • Empty Bind Variables
  • Locking
• Handling Non-Relational Data
• Restrictions
  • SQL Restrictions
    • Unsupported SQL Functions
    • SQL Syntax
    • Transaction Capability
    • Transactional Integrity
    • COMMIT or ROLLBACK in PL/SQL Cursor Loops
    • Pass-Through Feature
    • Database Links
    • Data Types
    • Encrypted Format Login
    • Data Dictionary Views and PL/SQL
  • VSAM Restrictions
    • General VSAM Restrictions
    • Restrictions Specific to VSAM (CICS)
    • Restrictions Specific to VSAM Batch

3 Normalizing Non-Relational Data

• Overview of Normalizing Non-Relational Data
• About Arrays
• Representing Metadata
• Methods of Handling Arrays
  • Virtual Views
  • Sequential Flattening (Bulk Load of Array Data)

4 Setting the Array Handling Policy

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

A Data Type Conversion

• Conversion of Atomic Data Types
• Conversion of Non-Atomic Data Types
• Conversion of Decimal Data Types
• Conversion of Scaled Data Types

B Supported SQL Syntax and Functions

• Supported SQL Statements
  • DELETE
  • INSERT
  • SELECT
  • UPDATE
• Oracle Functions
  • Functions Not Supported by Adabas
  • Functions Supported by Adabas
    • Arithmetic Operators
    • Comparison Operators
    • Group Functions
    • String Functions
    • Other Functions

C Data Dictionary

• Data Dictionary Support
  • Accessing the Gateway Data Dictionary
  • Supported Views and Tables
  • Default Column Values
• Adabas Data Dictionary Descriptions

D Globalization Support

• Character Set Terminology
• Globalization Support Settings

E Examples

• COBOL Copybook Example

Index