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

SQLCA in Assembler

With the CA Datacom/DB SQL preprocessor for Assembler, the possible formats of the SQLCA are:

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

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

In Assembler, the SQLCA can be generated in an area separate from the SQLDSECT by entering this line in the source (if this include is not used, the SQLCA is generated in the SQLDSECT by default):

 EXEC SQL INCLUDE SQLCA