UltraLite Embedded SQL User's Guide
  Data Access Using Embedded SQL
    The SQL Communication Area

SQLCA fields

The fields in the SQLCA have the following meanings:

• sqlcaid    An 8-byte character field that contains the string SQLCA as an identification of the SQLCA structure. This field helps in debugging when you are looking at memory contents.

• sqlcabc    A long integer that contains the length of the SQLCA structure (136 bytes).

• sqlcode    A long integer that specifies the error code when the database detects an error on a request. Definitions for the error codes can be found in the header file sqlerr.h. The error code is 0 (zero) for a successful operation, positive for a warning and negative for an error.

  You can access this field directly using the SQLCODE macro.

  For a list of error codes, see Database Error Messages.

• sqlerrml    The length of the information in the sqlerrmc field.

  UltraLite applications do not use this field.

• sqlerrmc    May contain one or more character strings to be inserted into an error message. Some error messages contain a placeholder string (%1) which is replaced with the text in this field.

  UltraLite applications do not use this field.

• sqlerrp    Reserved.

• sqlerrd    A utility array of long integers.

• sqlwarn    Reserved.

  UltraLite applications do not use this field.

• sqlstate    The SQLSTATE status value.

  UltraLite applications do not use this field.