Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

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

1 Introduction

• 1.1 Introduction to the Oracle Database Gateway
• 1.2 Release 11g Gateways
• 1.3 Gateway Capabilities
  • 1.3.1 Transparency at All Levels
  • 1.3.2 Extended Database Services
  • 1.3.3 Extended Advanced Networking, Internet and Intranet Support
  • 1.3.4 Dynamic Dictionary Mapping
  • 1.3.5 SQL
  • 1.3.6 Data Definition Language
  • 1.3.7 Data Control Language
  • 1.3.8 Passthrough and Native DB2 SQL
  • 1.3.9 Stored Procedures
  • 1.3.10 Languages
  • 1.3.11 Oracle Database Technology and Tools
  • 1.3.12 SQL*Plus
  • 1.3.13 Two-Phase Commit and Multi-Site Transactions
  • 1.3.14 Site Autonomy
  • 1.3.15 Migration and Coexistence
  • 1.3.16 Security
• 1.4 Terms
• 1.5 Architecture
• 1.6 Implementation
• 1.7 How the Gateway Works
• 1.8 Oracle Tools and the Gateway
  • 1.8.1 SQL*Plus
• 1.9 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.2 SQL Limitations

3 Using the Oracle Database Gateway for DRDA

• 3.1 Processing a Database Link
  • 3.1.1 Creating Database Links
  • 3.1.2 Dropping Database Links
  • 3.1.3 Examining Available Database Links
  • 3.1.4 Limiting the Number of Active Database Links
• 3.2 Accessing the Gateway
• 3.3 Accessing AS/400 File Members
• 3.4 Using the Synonym Feature
• 3.5 Performing Distributed Queries
  • 3.5.1 Two-Phase Commit Processing
  • 3.5.2 Distributed DRDA Transactions
• 3.6 Read-Only Gateway
• 3.7 Replicating in a Heterogeneous Environment
• 3.8 Copying Data from Oracle Database 11g to DRDA Server
• 3.9 Copying Data from DRDA Server to Oracle Database 11g
• 3.10 Tracing SQL Statements

4 Developing Applications

• 4.1 Gateway Appearance to Application Programs
  • 4.1.1 Fetch Reblocking
• 4.2 Using Oracle Stored Procedures with the Gateway
• 4.3 Using DRDA Server Stored Procedures with the Gateway
  • 4.3.1 Oracle Application and DRDA Server Stored Procedure Completion
  • 4.3.2 Procedural Feature Considerations with DB2
• 4.4 Database Link Behavior
• 4.5 Oracle Database SQL Construct Processing
  • 4.5.1 Compatible SQL Functions
  • 4.5.2 Translated SQL Functions
  • 4.5.3 Compensated SQL Functions
    • 4.5.3.1 Post-Processing
  • 4.5.4 Native Semantic SQL Functions
  • 4.5.5 DB2/OS390 SQL Compatibility
  • 4.5.6 DB2/Universal Database SQL Compatibility
  • 4.5.7 DB2/400 SQL Compatibility
• 4.6 Native Semantics
  • 4.6.1 SQL Functions That Can Be Enabled
  • 4.6.2 SQL Functions That Can Be Disabled
  • 4.6.3 SQL Set Operators and Clauses
• 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.4.1 Processing TIME and TIMESTAMP Data
    • 4.7.4.2 Processing DATE Data
    • 4.7.4.3 Performing Date Arithmetic
  • 4.7.5 Dates
  • 4.7.6 HS_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.8.1 Processing DDL Statements through Passthrough
  • 4.8.2 Using DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE
    • 4.8.2.1 Examples
  • 4.8.3 Retrieving Results Sets Through Passthrough
    • 4.8.3.1 Example
• 4.9 Oracle Data Dictionary Emulation on a DRDA Server
  • 4.9.1 Using the Gateway Data Dictionary
  • 4.9.2 Using the DRDA Catalog
• 4.10 Defining the Number of DRDA Cursors

5 Error Messages, Diagnosis, and Reporting

• 5.1 Interpreting Gateway Error Messages
  • 5.1.1 Errors Detected by the Oracle Database
  • 5.1.2 Errors Detected by the Gateway
  • 5.1.3 Errors Detected in the DRDA Software
  • 5.1.4 Communication Errors
  • 5.1.5 Errors Detected by the Server Database
• 5.2 Mapped Errors
• 5.3 Gateway Error Codes
• 5.4 SQL Tracing and the Gateway
  • 5.4.1 SQL Tracing in the Oracle Database
  • 5.4.2 SQL Tracing in the Gateway

A Oracle DB2 Data Dictionary Views

• A.1 Supported Views
• A.2 Data Dictionary View Tables
  • A.2.1 ALL_CATALOG
  • A.2.2 ALL_COL_COMMENTS
  • A.2.3 ALL_CONS_COLUMNS
  • A.2.4 ALL_CONSTRAINTS
  • A.2.5 ALL_INDEXES
  • A.2.6 ALL_IND_COLUMNS
  • A.2.7 ALL_OBJECTS
  • A.2.8 ALL_SYNONYMS
  • A.2.9 ALL_TABLES
  • A.2.10 ALL_TAB_COLUMNS
  • A.2.11 ALL_TAB_COMMENTS
  • A.2.12 ALL_USERS
  • A.2.13 ALL_VIEWS
  • A.2.14 COLUMN_PRIVILEGES
  • A.2.15 DICTIONARY
  • A.2.16 DUAL
  • A.2.17 TABLE_PRIVILEGES
  • A.2.18 USER_CATALOG
  • A.2.19 USER_COL_COMMENTS
  • A.2.20 USER_CONSTRAINTS
  • A.2.21 USER_CONS_COLUMNS
  • A.2.22 USER_INDEXES
  • A.2.23 USER_OBJECTS
  • A.2.24 USER_SYNONYMS
  • A.2.25 USER_TABLES
  • A.2.26 USER_TAB_COLUMNS
  • A.2.27 USER_TAB_COMMENTS
  • A.2.28 USER_USERS
  • A.2.29 USER_VIEWS

B Initialization Parameters

• B.1 Initialization Parameter File Syntax
• B.2 Oracle Database Gateway for DRDA Initialization Parameters
• B.3 Initialization Parameter Description
  • B.3.1 HS_CALL_NAME
  • B.3.2 HS_DB_DOMAIN
  • B.3.3 HS_DB_INTERNAL_NAME
  • B.3.4 HS_DB_NAME
  • B.3.5 HS_DESCRIBE_CACHE_HWM
  • B.3.6 HS_LANGUAGE
    • B.3.6.1 Character Sets
    • B.3.6.2 Language
    • B.3.6.3 Territory
  • B.3.7 HS_OPEN_CURSORS
  • B.3.8 HS_RPC_FETCH_REBLOCKING
  • B.3.9 HS_RPC_FETCH_SIZE
  • B.3.10 HS_TRANSACTION_MODEL
  • B.3.11 HS_FDS_FETCH_ROWS
  • B.3.12 IFILE
  • B.3.13 DRDA_CACHE_TABLE_DESC
  • B.3.14 DRDA_CAPABILITY
  • B.3.15 DRDA_CODEPAGE_MAP
  • B.3.16 DRDA_COMM_BUFLEN
  • B.3.17 DRDA_CONNECT_PARM
  • B.3.18 DRDA_DEFAULT_CCSID
  • B.3.19 DRDA_DESCRIBE_TABLE
  • B.3.20 DRDA_DISABLE_CALL
  • B.3.21 DRDA_FLUSH_CACHE
  • B.3.22 DRDA_GRAPHIC_CHAR_SIZE
  • B.3.23 DRDA_GRAPHIC_PAD_SIZE
  • B.3.24 DRDA_GRAPHIC_LIT_CHECK
  • B.3.25 DRDA_GRAPHIC_TO_MBCS
  • B.3.26 DRDA_ISOLATION_LEVEL
  • B.3.27 DRDA_LOCAL_NODE_NAME
  • B.3.28 DRDA_MBCS_TO_GRAPHIC
  • B.3.29 DRDA_OPTIMIZE_QUERY
  • B.3.30 DRDA_PACKAGE_COLLID
  • B.3.31 DRDA_PACKAGE_CONSTOKEN
  • B.3.32 DRDA_PACKAGE_NAME
  • B.3.33 DRDA_PACKAGE_OWNER
  • B.3.34 DRDA_PACKAGE_SECTIONS
  • B.3.35 DRDA_READ_ONLY
  • B.3.36 DRDA_RECOVERY_PASSWORD
  • B.3.37 DRDA_RECOVERY_USERID
  • B.3.38 DRDA_REMOTE_DB_NAME
  • B.3.39 FDS_CLASS
  • B.3.40 HS_NLS_NCHAR
  • B.3.41 LOG_DESTINATION
  • B.3.42 ORA_MAX_DATE
  • B.3.43 ORA_NLS11
  • B.3.44 ORACLE_DRDA_TCTL
  • B.3.45 ORACLE_DRDA_TRACE
  • B.3.46 TRACE_LEVEL
  • B.3.47 HS_NLS_DATE_FORMAT
  • B.3.48 HS_NLS_DATE_LANGUAGE
  • B.3.49 HS_NLS_NUMERIC_CHARACTER

C Globalization Support for DRDA

• C.1 Overview of Globalization Support Interactions
• C.2 Client and Oracle Database Configuration
• C.3 Gateway Language Interaction with DRDA Server
  • C.3.1 Gateway Configuration
  • C.3.2 Globalization Support Parameters in the Gateway Initialization File
    • C.3.2.1 HS_LANGUAGE
    • C.3.2.2 HS_NLS_NCHAR
    • C.3.2.3 HS_NLS_DATE_FORMAT
    • C.3.2.4 HS_NLS_DATE_LANGUAGE
• C.4 Gateway Codepage Map Facility
• C.5 Multibyte and Double-Byte Support in the Gateway
• C.6 Message Availability
• C.7 Example of Globalization Support Configuration

Index