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.