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 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)

3 Gateway Features and Restrictions

• Accessing IMS/DB Data
• SQL Support
  • Naming Rules
    • Rules for Naming Objects
    • Case Sensitivity
  • SQL Execution
    • Empty Strings
    • Empty Bind Variables
• Handling Non-Relational Data
• Hierarchical Modelling
• Constructing DLI Commands from SQL Requests
• Restrictions
  • SQL Restrictions
    • Unsupported SQL Functions
    • SQL Syntax
    • Transaction Capability
    • Transactional Integrity
    • Pass-Through Feature
    • Table and Column Names
    • Database Links
    • Stored Procedures
  • IMS/DB Restrictions
    • General IMS/DB Restrictions
    • Restrictions Specific to IMS-DLI
    • Restrictions Specific to IMS-DBCTL
    • Restrictions Specific to IMS-DBDC

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
• Hospital Database Example

Index