SQL communication area (SQLCA)
An SQLCA is a structure or collection of variables that is updated after each SQL statement executes. An application program that contains executable SQL statements must provide exactly one SQLCA, with a few exceptions.
The following exceptions exist:
- A program that is precompiled with the STDSQL(YES) option must not provide an SQLCA
- In some cases a Fortran program must provide more than one SQLCA.
In all host languages except REXX, the SQL INCLUDE statement can be used to provide the declaration of the SQLCA.
- In COBOL and assembler:
- The name of the storage area must be SQLCA.
- In PL/I, and C:
- The name of the structure must be SQLCA. Every executable SQL
statement must be within the scope of its declaration.
Unless noted otherwise, C is used to represent C/370 and C/C++ programming languages.
- In Fortran:
- The name of the COMMON area for the INTEGER variables of the SQLCA must be SQLCA1; the name of the COMMON area for the CHARACTER variables must be SQLCA2. An SQLCA definition is required for every subprogram that contains SQL statements. One is also needed for the main program if it contains SQL statements.
- In Java™:
- The DB2Sqlca class, which is an encapsulation of the SQLCA, should be used.
- In REXX:
- Db2 generates the SQLCA automatically. A REXX procedure cannot use the INCLUDE statement. The REXX SQLCA has a somewhat different format from SQLCAs for the other languages.