Previous Topic: SQL Communication AreaNext Topic: SQLSTATE


SQLCA

The SQL Communication Area (SQLCA) is a data structure used to return information regarding the success or failure of an SQL request.

Structure

Field

Meaning

Additional information

SQLCAID

Eye-catcher (SQLCA)

Initialized to SQLCA*.

SQLCODE

SQL error code

For SQLCODE values, see SQLCODE Values.

SQLCERC

Extended information error code

This field contains the reason code for error or warning conditions.

SQLCNRP

Number of rows processed by the SQL statement

 

SQLCNRRS

Number of dynamic results sets returned by a called SQL-invoked procedure

This is a 2-byte integer value.

SQLCSER

Offset into the user-provided SQL statement buffer where a syntax error was recognized

 

SQLCLNO

Source file line number from which the SQL statement was obtained

This field is maintained by the precompiler and is provided for use in forming error messages.

SQLCMCT

Count of messages issued for this request

 

SQLCARC

Reserved

 

SQLCFJB

Reserved

 

SQLCERRML

Length of error message text in SQLERRMC

 

SQLERRMC

Text of the error messages

This is a 256-byte field containing one or more messages. Each message is preceded by a one-byte binary field containing the length of the message text.

SQLSTATE

SQL status code

For SQLSTATE values, see SQLSTATE Values