4 Developing Applications

These topics provide information that is specific to the Oracle Database Gateway for DRDA.

• Gateway Appearance to Application Programs
  An application that is written to access information in a DRDA database interfaces with an Oracle database.
• Using Oracle Stored Procedures with the Gateway
  The gateway stored procedure support is an extension of Oracle stored procedures.
• Using DRDA Server Stored Procedures with the Gateway
  The procedural feature of the gateway enables invocation of native DRDA server stored procedures.
• Database Link Behavior
  A connection to the gateway is established through a database link when it is first used in an Oracle database session.
• Oracle Database SQL Construct Processing
  One of the most important features of the Oracle Database Gateway products is providing SQL transparency to the user and to the application programmer.
• DB2 UDB for z/OS SQL Compatibility
  This table describes DB2 UDB for z/OS compatibility.
• DB2 UDB for Unix, Linux, and Windows Compatibility
  This table describes DB2 UDB for Unix, Linux, and Windows compatibility.
• DB2 UDB for iSeries Compatibility
  This table describes DB2 UDB for iSeries compatibility.
• Native Semantics
  Some of the advanced SQL constructs that are supported by Oracle database may not be supported in the same manner by the DRDA database.
• DRDA Data Type to Oracle Data Type Conversion
  To move data between applications and the database, the gateway binds data values from a host variable or literal of a specific data type to a data type understood by the database.
• Passing Native SQL Statements through the Gateway
  The passthrough SQL feature enables an application developer to send a SQL statement directly to the DRDA server without the statement being interpreted by Oracle database.
• Oracle Data Dictionary Emulation on a DRDA Server
  The gateway optionally augments the DRDA database catalogs with data dictionary views modeled on the Oracle data dictionary.