Using CA InterTest for CICS with DB2 and SQL/DS Programs › SQL Return Codes › How to Handle SQL Error Codes › Display All the Fields in the SQLCA

Display All the Fields in the SQLCA

To view all the fields in the SQLCA after an SQL request, overtype the CORE command at the bottom of the display with one of the following, and press PF12:

CORE='SQLCA'     	(COBOL and PL/I)
CORE='Rn.SQLCA' 		(Assembler)

n

Indicates the register used to reference the SQLCA.

CA InterTest for CICS displays all the fields in the SQLCA in structured format as defined in the program.

Another method for viewing the SQLCA fields is to type the following command and press PF12:

CORE=SQLCA

CA InterTest for CICS displays the SQLCA fields using Assembler language field names.

Both methods should produce the same results, but the second method is available for programs not compiled or assembled symbolically.

Note: Neither command is valid until after an SQL request is issued.