To pass client SQL language requests through TRS to the DB2 on the mainframe, the TRS System Administrator must configure a default SQL language handler. This language handler is a TRS RPC that is mapped to an Mainframe Connect Server Option program on the mainframe that handles the interaction with DB2 UDB.
Sybase provides these programs:
For SQL language requests (including cursors, dynamic, and long-running transactions) on CICS, the Mainframe Connect DB2 UDB Option using the CICS transaction name AMD2
For SQL language requests on IMS or MVS, OmniSQL Access Module for DB2 using the transaction name SYRT
Use the instructions in this section to define the default SQL language handler RPC to TRS by specifying the mainframe transaction ID that handles language requests.