Table of Contents
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
-
1
Introduction to the Oracle Database Gateway for DRDA
- Overview ofthe Oracle Database Gateway for DRDA
-
Gateway Capabilities
- Transparency at All Levels
- Extended Database Services
- Extended Advanced Networking, Internet and Intranet Support
- Dynamic Dictionary Mapping
- SQL
- Data Definition Language
- Data Control Language
- Passthrough and Native DB2 SQL
- Stored Procedures
- Languages
- Oracle Database Technology and Tools
- SQL*Plus
- Two-Phase Commit and Multi-Site Transactions
- Site Autonomy
- Migration and Coexistence
- Security
- DRDA UDB Server Encryption support
- Terms
- Architecture
- Implementation
- How the Gateway Works
- Oracle Tools and the Gateway
- Features
-
2
Release Information
- Product Set
- Changes and Enhancements
- Product Migration
- Known Problems
-
Known Restrictions
-
DB2 Considerations
- DD Basic Tables and Views
- SUBSTR Function Post-Processed
- Data type Limitations
- Null Values and Stored Procedures
- String Concatenation of Numbers
- GLOBAL_NAMES Initialization Parameter
- DRDA Package and DB2 considerations
- Date Arithmetic
- Row Length Limitation
- LONG Data type in SQL*Plus
- Stored Procedures and Transaction Integrity
- SQL Limitations
-
DB2 Considerations
-
3
Using the Oracle Database Gateway for DRDA
- DRDA Gateway Features
- Processing a Database Link
- Accessing the Gateway
- Accessing i5/OS File Members
- Using the Synonym Feature
- Performing Distributed Queries
- Replicating in a Heterogeneous Environment
- Copying Data from Oracle Database to DRDA Server
- Copying Data from DRDA Server to Oracle Database
- Tracing SQL Statements
-
4
Developing Applications
- Gateway Appearance to Application Programs
- Using Oracle Stored Procedures with the Gateway
- Using DRDA Server Stored Procedures with the Gateway
- Database Link Behavior
- Oracle Database SQL Construct Processing
- Native Semantics
-
DRDA Data type to Oracle Data type Conversion
- Performing Character String Operations
- Converting Character String Data types
- Performing Graphic String Operations
- Performing Date and Time Operations
- Dates
- NLS_DATE_FORMAT Support
- Oracle TO_DATE Function
- Performing Numeric data type Operations
- Mapping the COUNT Function
- Performing Zoned Decimal Operations
- Passing Native SQL Statements through the Gateway
- Oracle Data Dictionary Emulation on a DRDA Server
- 5 Error Messages, Diagnosis, and Reporting
-
A
Oracle DB2 Data Dictionary Views
- Supported Views
- ALL_CATALOG
- ALL_COL_COMMENTS
- ALL_CONS_COLUMNS
- ALL_CONSTRAINTS
- ALL_INDEXES
- ALL_IND_COLUMNS
- ALL_OBJECTS
- ALL_SYNONYMS
- ALL_TABLES
- ALL_TAB_COLUMNS
- ALL_TAB_COMMENTS
- ALL_USERS
- ALL_VIEWS
- COLUMN_PRIVILEGES
- DICTIONARY
- DUAL
- TABLE_PRIVILEGES
- USER_CATALOG
- USER_COL_COMMENTS
- USER_CONSTRAINTS
- USER_CONS_COLUMNS
- USER_INDEXES
- USER_OBJECTS
- USER_SYNONYMS
- USER_TABLES
- USER_TAB_COLUMNS
- USER_TAB_COMMENTS
- USER_VIEWS
- USER_USERS
-
B
Initialization Parameters
- Initialization Parameter File Syntax
- Oracle Database Gateway for DRDA Initialization Parameters
- HS_CALL_NAME
- HS_DB_DOMAIN
- HS_DB_INTERNAL_NAME
- HS_DB_NAME
- HS_DESCRIBE_CACHE_HWM
- HS_LANGUAGE
- HS_LONG_PIECE_TRANSFER_SIZE
- HS_OPEN_CURSORS
- HS_RPC_FETCH_REBLOCKING
- HS_RPC_FETCH_SIZE
- HS_TRANSACTION_MODEL
- IFILE
- HS_FDS_CONNECT_INFO
- HS_FDS_RECOVERY_ACCOUNT
- HS_FDS_RECOVERY_PWD
- HS_FDS_FETCH_ROWS
- HS_FDS_TRACE_LEVEL
- HS_FDS_TRANSACTION_LOG
- HS_IDLE_TIMEOUT
- HS_FDS_MBCS_TO_GRAPHIC
- HS_FDS_GRAPHIC_TO_MBCS
- HS_FDS_TIMESTAMP_MAPPING
- HS_FDS_DATE_MAPPING
- HS_FDS_QUOTE_IDENTIFIER
- HS_FDS_CAPABILITY
- HS_FDS_TRANSACTION_ISOLATION
- HS_FDS_PACKAGE_COLLID
- HS_NLS_LENGTH_SEMANTICS
- HS_KEEP_REMOTE_COLUMN_SIZE
- HS_FDS_RESULTSET_SUPPORT
- HS_FDS_REMOTE_DB_CHARSET
- HS_FDS_SUPPORT_STATISTICS
- HS_FDS_RSET_RETURN_ROWCOUNT
- HS_FDS_AUTHENTICATE_USER
- HS_FDS_ENCRYPT_SESSION
- HS_FDS_VALIDATE_SERVER_CERT
- HS_FDS_TRUSTSTORE_FILE
- HS_FDS_TRUSTSTORE_PASSWORD
- HS_FDS_SQLLEN_INTERPRETATION
- HS_FDS_ARRAY_EXEC
- Index