SQLCA

Here are fields and data types for the SQLCA data structure.

Field C data type Contains
sqlcaid unsigned char Text string SQLCA.
sqlabc long Length of the SQLCA data structure.
sqlcode long Status code for the last-run SQL statement:
    0    The statement ran without error.
    1    The statement ran, but an exception was generated.
    100    A FETCH statement was issued, but no more rows satisfy the SELECT statement criteria used to define the cursor. No rows were processed.
    < 0 (negative)    The statement did not run due to an application, database, system, or network error.
sqlerrm   Error messages that consist of two parts.
  sqlerrml Length of the error message in sqlerrmc (0 to 70).
  short  
  sqlerrmc Text of the error message. Error messages longer than 70 bytes are truncated.
  unsigned char Reserved (diagnostic information).
sqlerrp unsigned char  
sqlerrd long Array of six integer status codes (codes not in the fields listed later are reserved).
  sqlerrd[1] Microsoft® SQL Server™ error number.
  sqlerrd[2] SQL Server severity level.
  sqlerrd[3] Number of rows affected.
  sqlwarn Eight warning flags, each containing a blank or W (flags not in the fields listed later are reserved).
sqlwarn[0] unsigned char Summary of all warning fields. Blank indicates no warnings.
sqlwarn[1] unsigned char W indicates a character string was truncated during output binding
sqlwarn[2] unsigned char Not used.
sqlwarn[3] unsigned char W indicates that the number of columns does not match the number of host variables.
sqlext unsigned char Reserved.
sqlstate unsigned char SQLSTATE run-time error codes.


Warning If the number of host variables and parameter markers does not match, SQLWARN3 is set to W. This condition is considered an exception (SQLCODE is set to +1). Exceeding the number of host variables or SQLDA data structure entries is fatal (SQLCODE = -19313). During a FETCH statement or a singleton SELECT statement, SQLWARN3 is set if the number of columns is not equal to the number of host variables (or SQLDA data structure entries). The lower of the two is the number of items actually processed. For more information about SQLCA, see Using the SQLCA Data Structure.


  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.