SQLCA Data Structure

The SQLCA data structure contains status information about the Embedded SQL statement that was 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;

SQLCA

Fields and datatypes for the SQLCA data structure are described in the following table.


Field and C datatype	Contains

sqlcaid
unsigned char	The text string SQLCA.
sqlabc
long	The length of the SQLCA data structure.
sqlcode
long	The 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 that was 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	The length of the error message in sqlerrmc (0 to 70).
short
sqlerrmc	The text of the error message. Error messages that are longer than 70 bytes are truncated.
unsigned char
sqlerrp
unsigned char	Reserved (diagnostic information).
sqlerrd
long	An array of six integer status codes (the codes that are not listed in the fields below are reserved).
sqlerrd[1]	SQL Server error number.
sqlerrd[2]	SQL Server severity level.
sqlerrd[3]	The number of rows affected.
sqlwarn	Eight warning flags, each containing a blank or W (those not listed in the fields below are reserved):
sqlwarn[0]
unsigned char	A summary of all warning fields. Blank indicates no warnings.
sqlwarn[1]
unsigned char	W indicates that 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 runtime 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 that are actually processed. For more information about SQLCA, see "Using the SQLCA Data Structure," in Chapter 2, "Embedded SQL Programming."