Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
- 1 Introduction to Oracle Database Provider for DRDA
- 2 Architecture of Oracle Database Provider for DRDA
-
3
Installation and Configuration of Oracle Database Provider for DRDA
- 3.1 About Installing Oracle Database Provider for DRDA
- 3.2 Configuring Oracle Database Provider for DRDA
- 3.3 Authorizing Oracle Database Provider for DRDA
- 3.4 Uninstalling Oracle Database Provider for DRDA
- 3.5 Configuration Parameters
-
4
SQL Translation
and Examples for Oracle Database Provider for DRDA
- 4.1 Overview of SQL Translation Process
- 4.2 Specifics of Translating DB2-Specific SQL Syntax
- 4.3 SQL Translator Interface Package
- 4.4 Using Third-Party SQL Translators
- 4.5 Using a Translator Management Script
- 4.6 Verifying the SQL Translator Profile
- 4.7 Altering the SQL Translation Profile
-
5
Administration and Customization of Oracle Database Provider for DRDA
- 5.1 Migration Steps using Oracle Database Provider for DRDA
- 5.2 Considerations for Using Oracle Database Provider for DRDA
- 5.3 Prerequisites to Installing Oracle Database Provider for DRDA
- 5.4 Administering DRDA Package Authority
- 5.5 Migrating DB2 Data
- 5.6 Retargeting the Application to Use Oracle Database
- 5.7 Translating SQL Statement and Typing Datatypes
- 6 Diagnostics and Maintenance of Oracle Database Provider for DRDA
-
7
Datatype Support and Conversion in Oracle Database Provider for DRDA
- 7.1 Overview of Datatype Conversion
- 7.2 Numerical Range Considerations; General
- 7.3 Numerical Range Considerations, for COBOL Users
-
7.4
Conversion between DRDA Datatypes to Oracle Datatypes
- 7.4.1 INTEGER
- 7.4.2 SMALLINT
- 7.4.3 BIGINT
- 7.4.4 float
- 7.4.5 DOUBLE PRECISION or FLOAT(b)
- 7.4.6 REAL or FLOAT(b)
- 7.4.7 DECIMAL(p,s)
- 7.4.8 DECIMAL(p,s) zoned
- 7.4.9 NUMERIC(p,s)
- 7.4.10 DECFLOAT(n=34)
- 7.4.11 DECFLOAT(n=16)
- 7.4.12 CHAR(n)
- 7.4.13 CHAR(n) for Bit Data
- 7.4.14 VARCHAR(n)
- 7.4.15 VARCHAR(n)
- 7.4.16 VARCHAR(n) for Bit Data
- 7.4.17 VARCHAR(n)
- 7.4.18 VARCHAR(n)
- 7.4.19 VARCHAR(n) for Bit Data
- 7.4.20 char(n+1)
- 7.4.21 char(n+1)
- 7.4.22 char(n) for Bit Data
- 7.4.23 VARGRAPHIC(n)
- 7.4.24 GRAPHIC(n)
- 7.4.25 VARGRAPHIC(n)
- 7.4.26 char(n) (Pascal L String)
- 7.4.27 char(n) for Bit Data (Pascal L String)
- 7.4.28 DATE
- 7.4.29 TIME
- 7.4.30 TIMESTAMP
- 7.4.31 (datalink)
- 7.4.32 BLOB
- 7.4.33 CLOB
- 7.4.34 DBCLOB
- 7.4.35 BLOB LOCATOR
- 7.4.36 CLOB LOCATOR
- 7.4.37 DBCLOB LOCATOR
- 7.4.38 boolean
- 7.4.39 BINARY(n)
- 7.4.40 VARBINARY(n)
- 7.4.41 XML
- 7.5 Conversion of Oracle Datatype to DRDA
- 7.6 Datatype Equivalence and Remapping
-
8
Data Dictionary for Oracle Database Provider for DRDA
- 8.1 Data Dictionary Emulation in Oracle Database Provider for DRDA
-
8.2
Data Dictionary Views for Oracle Database Provider for DRDA
- 8.2.1 ALL_DRDAASPACKAGE Data Dictionary View
- 8.2.2 ALL_DRDAASPACKAUTH Data Dictionary View
- 8.2.3 ALL_DRDAASPACKSIDE Data Dictionary View
- 8.2.4 DBA_DRDAASPACKAGE Data Dictionary View
- 8.2.5 DBA_DRDAASPACKAUTH Data Dictionary View
- 8.2.6 DBA_DRDAASPACKSIDE Data Dictionary View
- 8.2.7 DBA_DRDAASPACKSTMT Data Dictionary View
- 8.2.8 DBA_DRDAASTRACE Data Dictionary View
- 8.2.9 USER_DRDAASPACKAGE Data Dictionary View
- 8.2.10 USER_DRDAASPACKAUTH Data Dictionary View
- 8.2.11 USER_DRDAASPACKSIDE Data Dictionary View
- 8.2.12 USER_DRDAASPACKSTMT Data Dictionary View
- 8.2.13 USER_DRDAASTRACE Data Dictionary View
- 9 Error Codes Support in Oracle Database Provider for DRDA
- 10 Command-line Utility for Oracle Database Provider for DRDA
- 11 Security and Storage Considerations for Oracle Database Provider for DRDA
- 12 Restrictions on Using Oracle Database Provider for DRDA
- 13 PL/SQL Packages Used by Oracle Database Provider for DRDA
-
14
SQL Statement Support in Oracle Database Provider for DRDA
- 14.1 Overview of SQL Statement Support
- 14.2 SQL Clause Restrictions
-
14.3
Support for Special Registers
- 14.3.1 Retrieving Values from Special Registers
- 14.3.2 Setting Special Registers
-
14.3.3
Special Registers Supported by Oracle Database Provider for DRDA
- 14.3.3.1 APPLICATION ENCODING SCHEME
- 14.3.3.2 CLIENT_ACCTNG
- 14.3.3.3 CLIENT_APPLNAME
- 14.3.3.4 CLIENT_PROGRAMID
- 14.3.3.5 CLIENT_USERID
- 14.3.3.6 CLIENT_WRKSTNNAME
- 14.3.3.7 DATE
- 14.3.3.8 DBPARTITIONNUM
- 14.3.3.9 DEBUG MODE
- 14.3.3.10 DECFLOAT ROUNDING MODE
- 14.3.3.11 DEFAULT TRANSFORM GROUP
- 14.3.3.12 DEGREE
- 14.3.3.13 EXPLAIN MODE
- 14.3.3.14 EXPLAIN SNAPSHOT
- 14.3.3.15 FEDERATED ASYNCHRONY
- 14.3.3.16 IMPLICIT XMLPARSE OPTION
- 14.3.3.17 ISOLATION
- 14.3.3.18 LOCK TIMEOUT
- 14.3.3.19 LOCALE LC_TYPE
- 14.3.3.20 MAINTAINED TABLE TYPES FOR OPTIMIZATION
- 14.3.3.21 MEMBER
- 14.3.3.22 OPTIMIZATION HINT
- 14.3.3.23 PACKAGE PATH
- 14.3.3.24 PACKAGESET
- 14.3.3.25 PATH
- 14.3.3.26 PRECISION
- 14.3.3.27 QUERY ACCELERATION
- 14.3.3.28 QUERY OPTIMIZATION
- 14.3.3.29 REFRESH AGE
- 14.3.3.30 ROUTINE VERSION
- 14.3.3.31 RULES
- 14.3.3.32 SCHEMA
- 14.3.3.33 SERVER
- 14.3.3.34 SQL_CCFLAGS
- 14.3.3.35 SQLID
- 14.3.3.36 TIMESTAMP
- 14.3.3.37 USER
- 14.3.3.38 SESSION_USER
- 14.3.3.39 SYSTEM_USER
- 14.3.3.40 ENCRYPTION PASSWORD
- A Scripts for Creating and Maintaining Oracle Database Provider for DRDA
- B Package Binding Options in Oracle Database Provider for DRDA
- Glossary
- Index