An application that is written to access information in a DRDA database interfaces with an Oracle database.

When developing applications, keep the following information in mind:

• You must define the DRDA database to the application by using a database link that is defined in the Oracle database. Your application should specify tables that exist on a DRDA database by using the name that is defined in the database link. For example, assume that a database link is defined so that it names the DRDA database link DRDA, and also assume that an application needs to retrieve data from an Oracle database and from the DRDA database. Use the following SQL statement joining two tables together in your application:

  SELECT EMPNO, SALARY
  FROM EMP L, EMPS@DRDA R
  WHERE L.EMPNO = R.EMPNO
  

  In this example, EMP is a table on an Oracle database, and EMPS is a table on a DRDA server. You can also define a synonym or a view on the DRDA server table, and access the information without the database link suffix.

• You can read and write data to a defined DRDA database. SELECT, INSERT, UPDATE, and DELETE are all valid operations.
• A single transaction can write to one DRDA database and to multiple Oracle databases.
• Single SQL statements, using JOINs, can refer to tables in multiple Oracle databases, in multiple DRDA databases, or in both.

• Fetch Reblocking
  Oracle database supports fetch reblocking with the HS_RPC_FETCH_REBLOCKING parameter.