SQLCA fields

The SQLCA contains the following fields:

  • 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 in bytes of the SQLCA structure.

  • sqlcode   A long integer that contains an error code when the database detects an error on a request. Definitions for the error codes are in the header file %SQLANY12%\SDK\Include\sqlerr.h. The error code is 0 (zero) for a successful operation, a positive value for a warning, and a negative value for an error.

    You can access this field directly using the SQLCODE macro.

  • 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.

 See also