The SQL Communication 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.
For detailed information about the SQLCA structure, including a description of its fields, see the SQL Reference.
Language Syntax
C Structure
/* File: sqlca.h */
/* Structure: SQLCA */
/* ... */
SQL_STRUCTURE sqlca
{
_SQLOLDCHAR sqlcaid[8];
long sqlcabc;
#ifdef DB2_SQL92E
long sqlcade;
#else
long sqlcode;
#endif
short sqlerrml;
_SQLOLDCHAR sqlerrmc[70];
_SQLOLDCHAR sqlerrp[8];
long 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).
*
|