SQLCA Data Structure

Embedded SQL for C and SQL Server

Embedded SQL for C and SQL Server

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;