The figure shows the following SQLCA variables:

• SQLCAID Character string "SQLCA"

• SQLCABC Length of SQLCA data structure in bytes

• SQLCODE Oracle error message code

• SQLERRM Subrecord for storing error message

• SQLERRMC Text of error message

• SQLERRP Reserved for future use

• SQLERRD Array of six integer status codes

• SQLERRD(1) Reserved for future use

• SQLERRD(2) Reserved for future use

• SQLERRD(3) Number of rows processed

• SQLERRD(4) Reserved for future use

• SQLERRD(5) Parse error offset

• SQLERRD(6) Reserved for future use

• SQLWARN Array of eight warning flags

• SQLWARN(0) Another warning flag set

• SQLWARN(1) Character string truncated

• SQLWARN(2) no longer in use

• SQLWARN(3) SELECT list not equal to INTO list

• SQLWARN(4) DELETE or UPDATE without WHERE clause

• SQLWARN(5) Reserved for future use

• SQLWARN(6) No longer in use

• SQLWARN(7) No longer in use

• SQLEXT Reserved for future use