The SQL Communication Area (SQLCA) is a data structure used to return information regarding the success or failure of an SQL request.
|
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 |
|
Copyright © 2014 CA.
All rights reserved.
|
|