This is a text description of Figure 14-2, "Running DRDA Server Stored Procedures".

The functions illustrated in the figure are described in the surrounding text.

This is a simplified view of running a DB2 stored procedure on an Oracle application by calling the stored procedure from the DRDA server through the gateway.

The application calls the "emproc" stored procedure from an Oracle9i instance, which uses the gateway (TG4DRDA) to call the stored procedure from the DRDA server.

In this example, "emproc" is a DB2/MVS stored procedure.

The Oracle application is:

Program Code
.
.
empproc@db2(emp,
  pj,act,emt,ems,
  erre, type, code);
.
.
.
Program Code


The "DB2 empproc stored procedure" is:

Program Code
.
.
.
EXEC SQL UPDATE ...
.
.
.
EXEC SQL INSERT ...
.
.
.
Program Code