SQLCA data structure
The SQL communications area (SQLCA)
structure is used by the database manager to return error information to an application program.
This structure is updated after every API call and SQL statement
issued.
Language syntax
C Structure
/* File: sqlca.h */
/* Structure: SQLCA */
/* ... */
SQL_STRUCTURE sqlca
{
_SQLOLDCHAR sqlcaid[8];
sqlint32 sqlcabc;
#ifdef DB2_SQL92E
sqlint32 sqlcade;
#else
sqlint32 sqlcode;
#endif
short sqlerrml;
_SQLOLDCHAR sqlerrmc[70];
_SQLOLDCHAR sqlerrp[8];
sqlint32 sqlerrd[6];
_SQLOLDCHAR sqlwarn[11];
#ifdef DB2_SQL92E
_SQLOLDCHAR sqlstat[5];
#else
_SQLOLDCHAR sqlstate[5];
#endif
};
/* ... */
COBOL Structure
* File: sqlca.cbl
01 SQLCA SYNC.
05 SQLCAID PIC X(8) VALUE "SQLCA ".
05 SQLCABC PIC S9(9) COMP-5 VALUE 136.
05 SQLCODE PIC S9(9) COMP-5.
05 SQLERRM.
05 SQLERRP PIC X(8).
05 SQLERRD OCCURS 6 TIMES PIC S9(9) COMP-5.
05 SQLWARN.
10 SQLWARN0 PIC X.
10 SQLWARN1 PIC X.
10 SQLWARN2 PIC X.
10 SQLWARN3 PIC X.
10 SQLWARN4 PIC X.
10 SQLWARN5 PIC X.
10 SQLWARN6 PIC X.
10 SQLWARN7 PIC X.
10 SQLWARN8 PIC X.
10 SQLWARN9 PIC X.
10 SQLWARNA PIC X.
05 SQLSTATE PIC X(5).
*