SQL Communication Area

The SQL Communication Area (SQLCA) is a data structure used to return information regarding the success or failure of an SQL request.
idmscu19
The SQL Communication Area (SQLCA) is a data structure used to return information regarding the success or failure of an SQL request.
The following table describes that structure of the SQL Communication Area:
Field
Meaning
Additional information
SQLCAID
Eye-catcher (SQLCA)
Initialized to SQLCA*.
SQLCODE
SQL error code
SQLCERC
Extended information error code
This field contains the reason code for error or warning conditions.
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.
SQL status code
For SQLSTATE values, see SQLSTATE Values