Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Related Documents
• Typographic Conventions
• SQL*Plus Prompts
• Storage Measurements

1 Introduction

• Introduction to the Oracle Database Gateway for DRDA
• 12c Release 1 (12.1) Gateways
• 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
  • SQL*Plus
• Features

2 Release Information

• Product Set
• Changes and Enhancements
  • Gateway Password Encryption Tool
  • CHAR Semantics
  • Multi-byte Character Sets Ratio Suppression
  • IPv6 Support
  • Gateway Session IDLE Timeout
  • Result Sets and Stored Procedures
• 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
    • Oracle SQL Command INSERT
    • Oracle ROWID Column
    • Oracle Bind Variables
    • CONNECT BY Is Not Supported
    • CALLBACK links

3 Using the Oracle Database Gateway for DRDA

• DRDA Gateway Features
  • CHAR Semantics
  • Multi-byte Character Sets Ratio Suppression
  • IPv6 Support
  • Gateway Session IDLE Timeout
• Processing a Database Link
  • Creating Database Links
  • Dropping Database Links
  • Examining Available Database Links
  • Limiting the Number of Active Database Links
• Accessing the Gateway
• Accessing i5/OS File Members
• Using the Synonym Feature
• Performing Distributed Queries
  • Two-Phase Commit Processing
  • Distributed DRDA Transactions
• 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
  • Fetch Reblocking
• Using Oracle Stored Procedures with the Gateway
• Using DRDA Server Stored Procedures with the Gateway
  • Oracle Application and DRDA Server Stored Procedure Completion
  • Procedural Feature Considerations with DB2
  • Result Sets and Stored Procedures
    • OCI Program Fetching from Result Sets in Sequential Mode
    • PL/SQL Program Fetching from Result Sets in Sequential Mode
• Database Link Behavior
• Oracle Database SQL Construct Processing
  • Compatible SQL Functions
  • Translated SQL Functions
  • Compensated SQL Functions
    • Post-Processing
  • Native Semantic SQL Functions
  • DB2 UDB for z/OS SQL Compatibility
  • DB2 UDB for Unix, Linux, and Windows Compatibility
  • DB2 UDB for iSeries Compatibility
• Native Semantics
  • SQL Functions That Can Be Enabled
  • SQL Functions That Can Be Disabled
  • SQL Set Operators and Clauses
• 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
    • Processing TIME and TIMESTAMP Data
    • Processing DATE Data
    • Performing Date Arithmetic
  • 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
  • Processing DDL Statements through Passthrough
  • Using DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE
    • Examples
  • Retrieving Results Sets Through Passthrough
    • Example
• Oracle Data Dictionary Emulation on a DRDA Server
  • Using the Gateway Data Dictionary
  • Using the DRDA Catalog

5 Error Messages, Diagnosis, and Reporting

• Interpreting Gateway Error Messages
  • Errors Detected by the Gateway
  • Errors Detected in the DRDA Software
  • Errors Detected by the DRDA Server
• Mapped Errors
• SQL Tracing and the Gateway
  • SQL Tracing in the Oracle Database

A Oracle DB2 Data Dictionary Views

• Supported Views
• Data Dictionary View Tables
  • 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_USERS
  • USER_VIEWS

B Initialization Parameters

• Initialization Parameter File Syntax
• Oracle Database Gateway for DRDA Initialization Parameters
• Initialization Parameter Description
  • HS_CALL_NAME
  • HS_DB_DOMAIN
  • HS_DB_INTERNAL_NAME
  • HS_DB_NAME
  • HS_DESCRIBE_CACHE_HWM
  • HS_LANGUAGE
    • Character Sets
    • Language
    • Territory
  • 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_ISOLATION_LEVEL
  • 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_TRUSTSTORE_FILE
  • HS_FDS_TRUSTSTORE_PASSWORD
  • HS_FDS_SQLLEN_INTERPRETATION
  • HS_FDS_ARRAY_EXEC

Index