Skip Headers
Oracle® Database Gateway for VSAM User's Guide
11
g
Release 1 (11.1)
B31054-01
Index
Next
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
