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
- About Installing Oracle Database Provider for DRDA
- Configuring Oracle Database Provider for DRDA
- Authorizing Oracle Database Provider for DRDA
- Uninstalling Oracle Database Provider for DRDA
- Configuration Parameters
-
4
SQL Translation
and Examples for Oracle Database Provider for DRDA
- Overview of SQL Translation Process
- Specifics of Translating DB2-Specific SQL Syntax
- SQL Translator Interface Package
- Using Third-Party SQL Translators
- Using a Translator Management Script
- Verifying the SQL Translator Profile
- Altering the SQL Translation Profile
-
5
Administration and Customization of Oracle Database Provider for DRDA
- Migration Steps using Oracle Database Provider for DRDA
- Considerations for Using Oracle Database Provider for DRDA
- Prerequisites to Installing Oracle Database Provider for DRDA
- Administering DRDA Package Authority
- Migrating DB2 Data
- Retargeting the Application to Use Oracle Database
- 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
- Overview of Datatype Conversion
- Numerical Range Considerations; General
- Numerical Range Considerations, for COBOL Users
-
Conversion between DRDA Datatypes to Oracle Datatypes
- INTEGER
- SMALLINT
- BIGINT
- float
- DOUBLE PRECISION or FLOAT(b)
- REAL or FLOAT(b)
- DECIMAL(p,s)
- DECIMAL(p,s) zoned
- NUMERIC(p,s)
- DECFLOAT(n=34)
- DECFLOAT(n=16)
- CHAR(n)
- CHAR(n) for Bit Data
- VARCHAR(n)
- VARCHAR(n)
- VARCHAR(n) for Bit Data
- VARCHAR(n)
- VARCHAR(n)
- VARCHAR(n) for Bit Data
- char(n+1)
- char(n+1)
- char(n) for Bit Data
- VARGRAPHIC(n)
- GRAPHIC(n)
- VARGRAPHIC(n)
- char(n) (Pascal L String)
- char(n) for Bit Data (Pascal L String)
- DATE
- TIME
- TIMESTAMP
- (datalink)
- BLOB
- CLOB
- DBCLOB
- BLOB LOCATOR
- CLOB LOCATOR
- DBCLOB LOCATOR
- boolean
- BINARY(n)
- VARBINARY(n)
- XML
- Conversion of Oracle Datatype to DRDA
- Datatype Equivalence and Remapping
-
8
Data Dictionary for Oracle Database Provider for DRDA
- Data Dictionary Emulation in Oracle Database Provider for DRDA
-
Data Dictionary Views for Oracle Database Provider for DRDA
- ALL_DRDAASPACKAGE Data Dictionary View
- ALL_DRDAASPACKAUTH Data Dictionary View
- ALL_DRDAASPACKSIDE Data Dictionary View
- DBA_DRDAASPACKAGE Data Dictionary View
- DBA_DRDAASPACKAUTH Data Dictionary View
- DBA_DRDAASPACKSIDE Data Dictionary View
- DBA_DRDAASPACKSTMT Data Dictionary View
- DBA_DRDAASTRACE Data Dictionary View
- USER_DRDAASPACKAGE Data Dictionary View
- USER_DRDAASPACKAUTH Data Dictionary View
- USER_DRDAASPACKSIDE Data Dictionary View
- USER_DRDAASPACKSTMT Data Dictionary View
- 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
- Overview of SQL Statement Support
- SQL Clause Restrictions
-
Support for Special Registers
- Retrieving Values from Special Registers
- Setting Special Registers
-
Special Registers Supported by Oracle Database Provider for DRDA
- APPLICATION ENCODING SCHEME
- CLIENT_ACCTNG
- CLIENT_APPLNAME
- CLIENT_PROGRAMID
- CLIENT_USERID
- CLIENT_WRKSTNNAME
- DATE
- DBPARTITIONNUM
- DEBUG MODE
- DECFLOAT ROUNDING MODE
- DEFAULT TRANSFORM GROUP
- DEGREE
- EXPLAIN MODE
- EXPLAIN SNAPSHOT
- FEDERATED ASYNCHRONY
- IMPLICIT XMLPARSE OPTION
- ISOLATION
- LOCK TIMEOUT
- LOCALE LC_TYPE
- MAINTAINED TABLE TYPES FOR OPTIMIZATION
- MEMBER
- OPTIMIZATION HINT
- PACKAGE PATH
- PACKAGESET
- PATH
- PRECISION
- QUERY ACCELERATION
- QUERY OPTIMIZATION
- REFRESH AGE
- ROUTINE VERSION
- RULES
- SCHEMA
- SERVER
- SQL_CCFLAGS
- SQLID
- TIMESTAMP
- USER
- SESSION_USER
- SYSTEM_USER
- 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