SQLCA record

Acronym for SQL Communications Area. It is a built-in record that stores information about the most recently executed SQL statement. The SQLCODE member stores the result code returned by the database engine; it is used for error handling by 4GL and the Informix embedded language products. The SQLAWARN member is a string of eight characters whose individual characters signal warning conditions. SQLERRD is an array of six integers that returns information about the results of an SQL statement.

See also database engine, error handling, status variable.