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

SQLCA in COBOL

With the CA Datacom/DB SQL Preprocessor for COBOL, the possible formats of the SQLCA are:

• CA Datacom/DB format (see SQLCA - CA Datacom/DB Format (COBOL)). For a table containing descriptions of this example, see Description of SQLCA in CA Datacom/DB Format.
• DB2 format (see SQLCA - DB2 Format (COBOL)). For a table containing descriptions of this example, see Description of SQLCA in DB2 Format.

In COBOL, the Preprocessor always generates the SQLCA structure. An INCLUDE SQLCA is not required. The Preprocessor ignores the INCLUDE directive if SQLCA is the member name. You may therefore either explicitly code the include of the SQLCA or omit it.

In DB2 mode, the CA Datacom/DB SQL Communication Area (SQLCA) used is the DB2 SQLCA, including the values for SQLCODE and SQLERRM.