REXX/CICS Db2 interface

The REXX/CICS® Db2® interface provides a means of executing SQL statements and Db2 commands from a REXX exec.

The SQL are prepared and executed dynamically. You issue the Db2 commands by using theDb2 instrumentation facility interface (IFI). The REXX/CICS Db2 interface provides the results of the SQL in REXX predefined variables. The REXX/CICS Db2 interface supports DB2® Version 2.3 and later. This information explains how to use the interface to Db2 from REXX/CICS.

For more information about SQL statements or Db2 commands, see SQL: The language of Db2 in Db2 for z/OS product documentation and Db2 commands. For more information about IFI, see Programming for the instrumentation facility interface (IFI) in Db2 for z/OS product documentation.

Note: REXX/CICS transaction identifiers must be entered in the Db2 Resource Control Table (RCT). Refer to sample JCL CICRCT.