3 Using the Oracle Database Gateway for DRDA

Using the Oracle Database Gateway for DRDA involves connecting to the corresponding gateway system and the remote DRDA database associated with the gateway.

• DRDA Gateway Features
  These topics describe DRDA gateway features.
• Processing a Database Link
  The database and application administrators of a distributed database system are responsible for managing the database links that define paths to the Oracle Database Gateway for DRDA.
• Accessing the Gateway
  This topic describes how to access the gateway.
• Accessing i5/OS File Members
  Access to i5/OS files and file members is not specifically controlled by DRDA or the gateway.
• Using the Synonym Feature
  You can provide complete data, location, and network transparency by using the synonym feature of Oracle database.
• Performing Distributed Queries
  The Oracle Database Gateway technology enables the execution of distributed queries that join data in an Oracle database and in DRDA servers and data from any other data store for which Oracle provides a gateway.
• Replicating in a Heterogeneous Environment
  Oracle Database Gateway for DRDA provides a number of options for replicating Oracle and non-Oracle data throughout the enterprise.
• Copying Data from Oracle Database to DRDA Server
  This Oracle SQL INSERT command now works with the CALLBACK feature.
• Copying Data from DRDA Server to Oracle Database
  The CREATE TABLE command enables you to copy data from a DRDA server to Oracle database.
• Tracing SQL Statements
  SQL statements issued through the gateway can be changed before reaching the DRDA database.