Defining the SQL communications area, SQLSTATE, and SQLCODE in REXX

When Db2 prepares a REXX program that contains SQL statements, Db2 automatically includes an SQLCA in the program.

About this task

The REXX SQLCA differs from the SQLCA for other languages. The REXX SQLCA consists of a set of separate variables, rather than a structure.

The SQLCA has the following forms:

  • A set of simple variables
  • A set of compound variables that begin with the stem SQLCA

The simple variables is the default form of the SQLCA. Using CALL SQLEXEC results in the compound stem variables. Otherwise, the attachment command used determines the form of the SQLCA. If you use the ADDRESS DSNREXX 'CONNECT' ssid syntax to connect to Db2, the SQLCA variables are a set of simple variables. If you use the CALL SQLDBS 'ATTACH TO' syntax to connect to Db2, the SQLCA variables are compound variables that begin with the stem SQLCA.

Switching forms of the SQLCA within an application is not recommended.