Table of Contents
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
- 1
Introduction to the Oracle Database Gateway for DRDA
- 1.1 Overview ofthe Oracle Database Gateway for DRDA
- 1.2
Gateway Capabilities
- 1.2.1 Transparency at All Levels
- 1.2.2 Extended Database Services
- 1.2.3 Extended Advanced Networking, Internet and Intranet Support
- 1.2.4 Dynamic Dictionary Mapping
- 1.2.5 SQL
- 1.2.6 Data Definition Language
- 1.2.7 Data Control Language
- 1.2.8 Passthrough and Native DB2 SQL
- 1.2.9 Stored Procedures
- 1.2.10 Languages
- 1.2.11 Oracle Database Technology and Tools
- 1.2.12 SQL*Plus
- 1.2.13 Two-Phase Commit and Multi-Site Transactions
- 1.2.14 Site Autonomy
- 1.2.15 Migration and Coexistence
- 1.2.16 Security
- 1.2.17 DRDA UDB Server Encryption support
- 1.3 Terms
- 1.4 Architecture
- 1.5 Implementation
- 1.6 How the Gateway Works
- 1.7 Oracle Tools and the Gateway
- 1.8 Features
- 2
Release Information
- 2.1 Product Set
- 2.2 Changes and Enhancements
- 2.3 Product Migration
- 2.4 Known Problems
- 2.5
Known Restrictions
- 2.5.1
DB2 Considerations
- 2.5.1.1 DD Basic Tables and Views
- 2.5.1.2 SUBSTR Function Post-Processed
- 2.5.1.3 Data type Limitations
- 2.5.1.4 Null Values and Stored Procedures
- 2.5.1.5 String Concatenation of Numbers
- 2.5.1.6 GLOBAL_NAMES Initialization Parameter
- 2.5.1.7 DRDA Package and DB2 considerations
- 2.5.1.8 Date Arithmetic
- 2.5.1.9 Row Length Limitation
- 2.5.1.10 LONG Data type in SQL*Plus
- 2.5.1.11 Stored Procedures and Transaction Integrity
- 2.5.2 SQL Limitations
- 2.5.1
DB2 Considerations
- 3
Using the Oracle Database Gateway for DRDA
- 3.1 DRDA Gateway Features
- 3.2 Processing a Database Link
- 3.3 Accessing the Gateway
- 3.4 Accessing i5/OS File Members
- 3.5 Using the Synonym Feature
- 3.6 Performing Distributed Queries
- 3.7 Replicating in a Heterogeneous Environment
- 3.8 Copying Data from Oracle Database to DRDA Server
- 3.9 Copying Data from DRDA Server to Oracle Database
- 3.10 Tracing SQL Statements
- 4
Developing Applications
- 4.1 Gateway Appearance to Application Programs
- 4.2 Using Oracle Stored Procedures with the Gateway
- 4.3 Using DRDA Server Stored Procedures with the Gateway
- 4.4 Database Link Behavior
- 4.5 Oracle Database SQL Construct Processing
- 4.6 Native Semantics
- 4.7
DRDA Data type to Oracle Data type Conversion
- 4.7.1 Performing Character String Operations
- 4.7.2 Converting Character String Data types
- 4.7.3 Performing Graphic String Operations
- 4.7.4 Performing Date and Time Operations
- 4.7.5 Dates
- 4.7.6 NLS_DATE_FORMAT Support
- 4.7.7 Oracle TO_DATE Function
- 4.7.8 Performing Numeric data type Operations
- 4.7.9 Mapping the COUNT Function
- 4.7.10 Performing Zoned Decimal Operations
- 4.8 Passing Native SQL Statements through the Gateway
- 4.9 Oracle Data Dictionary Emulation on a DRDA Server
- 5 Error Messages, Diagnosis, and Reporting
- A
Oracle DB2 Data Dictionary Views
- A.1 Supported Views
- A.2 ALL_CATALOG
- A.3 ALL_COL_COMMENTS
- A.4 ALL_CONS_COLUMNS
- A.5 ALL_CONSTRAINTS
- A.6 ALL_INDEXES
- A.7 ALL_IND_COLUMNS
- A.8 ALL_OBJECTS
- A.9 ALL_SYNONYMS
- A.10 ALL_TABLES
- A.11 ALL_TAB_COLUMNS
- A.12 ALL_TAB_COMMENTS
- A.13 ALL_USERS
- A.14 ALL_VIEWS
- A.15 COLUMN_PRIVILEGES
- A.16 DICTIONARY
- A.17 DUAL
- A.18 TABLE_PRIVILEGES
- A.19 USER_CATALOG
- A.20 USER_COL_COMMENTS
- A.21 USER_CONSTRAINTS
- A.22 USER_CONS_COLUMNS
- A.23 USER_INDEXES
- A.24 USER_OBJECTS
- A.25 USER_SYNONYMS
- A.26 USER_TABLES
- A.27 USER_TAB_COLUMNS
- A.28 USER_TAB_COMMENTS
- A.29 USER_VIEWS
- A.30 USER_USERS
- B
Initialization Parameters
- B.1 Initialization Parameter File Syntax
- B.2 Oracle Database Gateway for DRDA Initialization Parameters
- B.3 HS_CALL_NAME
- B.4 HS_DB_DOMAIN
- B.5 HS_DB_INTERNAL_NAME
- B.6 HS_DB_NAME
- B.7 HS_DESCRIBE_CACHE_HWM
- B.8 HS_LANGUAGE
- B.9 HS_LONG_PIECE_TRANSFER_SIZE
- B.10 HS_OPEN_CURSORS
- B.11 HS_RPC_FETCH_REBLOCKING
- B.12 HS_RPC_FETCH_SIZE
- B.13 HS_TRANSACTION_MODEL
- B.14 IFILE
- B.15 HS_FDS_CONNECT_INFO
- B.16 HS_FDS_RECOVERY_ACCOUNT
- B.17 HS_FDS_RECOVERY_PWD
- B.18 HS_FDS_FETCH_ROWS
- B.19 HS_FDS_TRACE_LEVEL
- B.20 HS_FDS_TRANSACTION_LOG
- B.21 HS_IDLE_TIMEOUT
- B.22 HS_FDS_MBCS_TO_GRAPHIC
- B.23 HS_FDS_GRAPHIC_TO_MBCS
- B.24 HS_FDS_TIMESTAMP_MAPPING
- B.25 HS_FDS_DATE_MAPPING
- B.26 HS_FDS_QUOTE_IDENTIFIER
- B.27 HS_FDS_CAPABILITY
- B.28 HS_FDS_TRANSACTION_ISOLATION
- B.29 HS_FDS_PACKAGE_COLLID
- B.30 HS_NLS_LENGTH_SEMANTICS
- B.31 HS_KEEP_REMOTE_COLUMN_SIZE
- B.32 HS_FDS_RESULTSET_SUPPORT
- B.33 HS_FDS_REMOTE_DB_CHARSET
- B.34 HS_FDS_SUPPORT_STATISTICS
- B.35 HS_FDS_RSET_RETURN_ROWCOUNT
- B.36 HS_FDS_AUTHENTICATE_USER
- B.37 HS_FDS_ENCRYPT_SESSION
- B.38 HS_FDS_VALIDATE_SERVER_CERT
- B.39 HS_FDS_TRUSTSTORE_FILE
- B.40 HS_FDS_TRUSTSTORE_PASSWORD
- B.41 HS_FDS_SQLLEN_INTERPRETATION
- B.42 HS_FDS_ARRAY_EXEC
- Index