Skip Headers
Oracle® Database Gateway for Adabas User's Guide
11
g
Release 2 (11.2)
Part Number E12074-01
Home
Book List
Index
Master Index
Contact Us
Next
PDF
·
Mobi
·
ePub
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 Adabas Data
Exporting Predict Metadata into Adabas ADD
SQL 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
COMMIT or ROLLBACK in PL/SQL Cursor Loops
Pass-Through Feature
Database Links
Data Types
Encrypted Format Login
Data Dictionary Views and PL/SQL
Adabas Restrictions
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 Array Handling Policy for a Specific Table
A
Data Type Conversion
Conversion of Predict Metadata
Conversion of Metadata from DDM Files
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
Index
Scripting on this page enhances content navigation, but does not change the content in any way.