SQL Communication Area (SQLCA) in COBOL
The SQLCA provides the programmer with comprehensive information about the success or failure of each SQL command.
The following is the declaration of the SQLCA structure in COBOL:
01 SQLCA.
02 SQLCAID PIC X(8) VALUE "sqlca ".
02 SQLCABC PIC S9(9) COMP VALUE +136.
02 SQLCODE PIC S9(9) COMP VALUE +0.
02 SQLERRM.
49 SQLERRML PIC S9(4) COMP.
49 SQLERRMC PIC X(70).
02 SQLERRP PIC X(8).
02 SQLERRD OCCURS 6 TIMES
PIC S9(9) COMP.
02 SQLWARN.
03 SQLWARN0 PIC X.
03 SQLWARN1 PIC X.
03 SQLWARN2 PIC X.
03 SQLWARN3 PIC X.
03 SQLWARN4 PIC X.
03 SQLWARN5 PIC X.
03 SQLWARN6 PIC X.
03 SQLWARN7 PIC X.
02 SQLEXT PIC X(8).