The SQLCA Data Structure

The SQLCA data structure for OpenESQL and the DB2 ECM is shown below:

 01 SQLCA.
     05  SQLCAID         PIC X(8)         VALUE "SQLCA   ".
     05  SQLCABC         PIC S9(9) COMP-5 VALUE 136.
     05  SQLCODE         PIC S9(9) COMP-5 VALUE 0.
     05  SQLERRM.
         49  SQLERRML    PIC S9(4) COMP-5.
         49  SQLERRMC    PIC X(70).
     05  SQLERRP         PIC X(8).
     05  SQLERRD         PIC S9(9) COMP-5 OCCURS 6 VALUE 0.
     05  SQLWARN.
         10  SQLWARN0    PIC X.
         10  SQLWARN1    PIC X.
         10  SQLWARN2    PIC X.
         10  SQLWARN3    PIC X.
         10  SQLWARN4    PIC X.
         10  SQLWARN5    PIC X.
         10  SQLWARN6    PIC X.
         10  SQLWARN7    PIC X.
     05  SQLEXT.
         10  SQLWARN8    PIC X.
         10  SQLWARN9    PIC X.
         10  SQLWARN10   PIC X.
         10  SQLWARNA    PIC X REDEFINES SQLWARN10.
     05  SQLSTATE    PIC X(5).

Oracle, Sybase and Informix all have different versions of the SQLCA. The Oracle, Sybase and Informix SQLCAs all have a SQLCODE, SQLERRML, SQLERRMC and a SQLWARN. The sizes and the positions of these fields can differ among the precompilers

The table below describes the contents of the SQLCA data structure:

Field Contents
SQLCAID The text string "SQLCA".
SQLCABC The length of the SQLCA data structure.
SQLCODE The status code for the last-run SQL statement:
   
SQLERRML The length of the error message in SQLERRMC (0–70).
SQLERRMC Error message text. Error messages longer than 70 bytes are truncated.
SQLERRP Reserved (diagnostic information).
SQLERRD An array of six integer status codes (those not listed below are reserved):
SQLERRD(1) SQL server error number.
SQLERRD(2) SQL server severity.
SQLERRD(3) The number of rows affected.
SQLWARN Eight warning flags, each containing a blank or "W" (those not listed below are reserved): A warning flag will be set if SQLCODE contains a value of +1:
SQLWARN0 A summary of all warning fields. Blank means there are no warnings.
SQLWARN1 "W" indicates that data was truncated on output to a character host variable.
SQLWARN2 "W" indicates that a null value exists, but no indicator variable was provided.
SQLWARN3 "W" indicates that the number of columns is less than the number of host variables or that the number of host variables provided does not match the number of parameter markers in the statement. The lower of the two numbers has been used.
SQLWARN4 "W" indicates a singleton select that returns more than one row (only the first row is returned).
FILLER Reserved.
SQLSTATE Status indicator for the last-run SQL statement.