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 Adabas Data
  • 2.1.1 Exporting Predict Metadata into Adabas ADD
• 2.2 SQL Support
  • 2.2.1 Pass-Through Feature
  • 2.2.2 Naming Rules
    • 2.2.2.1 Rules for Naming Objects
    • 2.2.2.2 Case Sensitivity
  • 2.2.3 Data Types
    • 2.2.3.1 Binary Literal Notation
    • 2.2.3.2 Data Type Conversion
  • 2.2.4 SQL Execution
    • 2.2.4.1 Row Selection
    • 2.2.4.2 Empty Strings
    • 2.2.4.3 Empty Bind Variables
  • 2.2.5 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 COMMIT or ROLLBACK in PL/SQL Cursor Loops
    • 2.4.1.5 Pass-Through Feature
    • 2.4.1.6 Database Links
    • 2.4.1.7 Data Types
    • 2.4.1.8 Encrypted Format Login
    • 2.4.1.9 Data Dictionary Views and PL/SQL
  • 2.4.2 Adabas Restrictions

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 Predict Metadata
• A.2 Conversion of Metadata from DDM Files

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 Adabas
  • B.2.2 Functions Supported by Adabas
    • 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 Adabas Data Dictionary Descriptions

D Globalization Support

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

Index