CA Datacom/DB SQL Preprocessors › SQL Communication Area (SQLCA) › SQLCA in PL/I

SQLCA in PL/I

With the CA Datacom/DB SQL Preprocessor for PL/I the possible formats of the SQLCA are:

• CA Datacom/DB format for ANSI (see SQLCA - CA Datacom/DB Format (PL/I)) and for non-ANSI (see SQLCA - CA Datacom/DB Format (PL/I)). For a table containing descriptions of these examples, see Description of SQLCA in CA Datacom/DB Format.
• DB2 format for ANSI (see SQLCA - DB2 Format (PL/I)) and for non-ANSI (see DB2 format (non-ANSI)). For a table containing descriptions of these examples, see Description of SQLCA in DB2 Format.

In DB2 mode in PL/I, the CA Datacom/DB SQL Communication Area (SQLCA) used is the DB2 SQLCA, including the values for SQLCODE (for the non-ANSI version) or SQLCADE (for the ANSI 86 version), and SQLERRM.