Application requester driver programs

 

To complement database access provided by products that implement Distributed Relational Database Architecture™ (DRDA^®), DB2^® UDB for iSeries™ provides an interface for writing exit programs on a DB2 UDB for iSeries application requester to process SQL requests. Such an exit program is called an application requester driver (ARD).

The system calls the ARD program during the following operations:

• During package creation performed using the CRTSQLPKG or CRTSQLxxx commands, when the relational database (RDB) parameter matches the RDB name corresponding to the ARD program.

• Processing of SQL statements when the current connection is to an RDB name corresponding to the ARD program.

These calls allow the ARD program to pass the SQL statements and information about the statements to a remote relational database and return results back to the system. The system then returns the results to the application or the user. Access to relational databases accessed by ARD programs appears like access to DRDA application servers in the unlike environment. However, not all DRDA function is supported in the ARD environment. Examples of function not supported are Large objects (LOBs) and long passwords (passphrases).

 

Parent topic:

Distributed relational database function and SQL