SQLCA Data Structure

The SQLCA data structure contains status information about the Embedded SQL statement last executed. The structure definition for SQLCA (from Sqlca.h) looks like this:

// SQL Communication Area - SQLCA
typedef struct sqlca
{
  unsigned char  
  sqlcaid[EYECATCH_LEN]; // Eyecatcher = 'SQLCA   '
  long sqlcabc; // SQLCA size in bytes = 136
  long sqlcode; // SQL return code
  short sqlerrml; // Length for SQLERRMC
  unsigned char  
  sqlerrmc[SQLERRMC_SIZ]; // Error message tokens
  unsigned char sqlerrp[8]; // Diagnostic information
  long sqlerrd[6]; // Diagnostic information
  unsigned char sqlwarn[8]; // Warning flags
  unsigned char sqlext[3]; // Reserved
  unsigned char sqlstate[5]; // new member
} SQLCA;    

  


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