The REXX SQLCA
The REXX SQLCA consists of a set of variables, rather than a structure. DB2® makes the SQLCA available to your application automatically.
The following table lists the variables in a REXX SQLCA.
| Variable | Contents |
|---|---|
| SQLCODE | Contains the SQL return code. |
| SQLERRMC | Contains one or more tokens, separated by X'FF', that are substituted for variables in the descriptions of error conditions. It might contain truncated tokens. A message length of 70 bytes indicates a possible truncation. |
| SQLERRP | Provides a product signature and, in the case of an error, diagnostic information such as the name of the module that detected the error. For DB2 for z/OS®, the product signature is 'DSN'. |
| SQLERRD.1 | For a sensitive static cursor, contains the number
of rows in a result table when the cursor position is after the last
row (that is, when SQLCODE is equal to +100). SQLERRD(1) can also contain an internal error code. |
| SQLERRD.2 | For a sensitive static cursor, contains the number
of rows in a result table when the cursor position is after the last
row (that is, when SQLCODE is equal to +100). SQLERRD(2) can also contain an internal error code. |
| SQLERRD.3 | Contains the number of rows that
qualified for the operation after an SQL data change statement (but
not rows deleted as a result of CASCADE delete). For the OPEN of a
cursor for a SELECT with an SQL data change statement or for a SELECT
INTO, SQLERRD(3) contains the number of rows affected by the embedded
data change statement. Set to 0 if the SQL statement fails, indicating
that all changes made in executing the statement were canceled. Set
to -1 for a mass delete from a table in a segmented table space, for
a truncate operation, or a delete from a view when neither the DELETE
statement nor the definition of the view included selection criteria.
For rowset-oriented FETCH statements, contains the number of rows returned in the rowset. For SQLCODES -911 and -913, SQLERRD(3) contains the reason code for the timeout or deadlock. After successful execution of the REFRESH TABLE statement, SQLERRD(3) contains the number of rows inserted into the materialized query table. When an error is encountered in parsing a dynamic statement, or when parsing, binding, or executing a native SQL procedure, SQLERRD(3) will contain the line number where the error was encountered. The sixth byte of SQLCAID must be 'L' for this to be a valid line number. This value will be meaningful only if the statement source contains new line control characters. This information is not returned for an external SQL procedure. |
| SQLERRD.4 | Generally, contains timerons, a short floating-point value that indicates a rough relative estimate of resources required. This value does not reflect an estimate of the time required to execute the SQL statement. After you prepare an SQL statement, you can use this field as an indicator of the relative cost of the prepared SQL statement. For a particular statement, this number can vary with changes to the statistics in the catalog. This value is subject to change between releases of DB2 for z/OS. |
| SQLERRD.5 | Contains the position or column of a syntax error for a PREPARE or EXECUTE IMMEDIATE statement. |
| SQLERRD.6 | Contains an internal error code. |
| SQLWARN.0 | Contains a blank if no other indicator is set to a warning condition (that is, no other indicator contains a W or Z). Contains a W if at least one other indicator contains a W or Z. |
| SQLWARN.1 | Contains a W if the value of a string column was truncated when assigned to a host variable. Contains an N for non-scrollable cursors and S for scrollable cursors after the OPEN CURSOR or ALLOCATE CURSOR statement. |
| SQLWARN.2 | Contains a W if null values were eliminated from the argument of an aggregate function; not necessarily set to W for the MIN function because its results are not dependent on the elimination of null values. |
| SQLWARN.3 | Contains a W if the number of result columns is larger than the number of host variables. Contains Z if the ASSOCIATE LOCATORS statement contains fewer locators than the stored procedure returned. |
| SQLWARN.4 | Contains a W if a prepared UPDATE or DELETE statement does not include a WHERE clause. For a scrollable cursor, contains a D for sensitive dynamic cursors, I for insensitive cursors, and S for sensitive static cursors after the OPEN CURSOR or ALLOCATE CURSOR statement; otherwise, blank if cursor is not scrollable. |
| SQLWARN.5 | Contains a W if the SQL statement was not executed because it is not a valid SQL statement in DB2 for z/OS. Contains a character value of 1 (read only), 2 (read and delete), or 4 (read, delete, and update) to reflect capability of the cursor after the OPEN CURSOR or ALLOCATE CURSOR statement. |
| SQLWARN.6 | Contains a W if the addition of a month or year duration to a DATE or TIMESTAMP value results in an invalid day (for example, June 31). Indicates that the value of the day was changed to the last day of the month to make the result valid. |
| SQLWARN.7 | Contains a W if one or more nonzero digits were eliminated from the fractional part of a number that was used as the operand of a decimal multiply or divide operation. |
| SQLWARN.8 | Contains a W if a character that could not be converted was replaced with a substitute character. |
| SQLWARN.9 | Contains a W if arithmetic exceptions were ignored during COUNT or COUNT_BIG processing. Contains a Z if the stored procedure returned multiple result sets. |
| SQLWARN.10 | Contains a W if at least one character field of the SQLCA is invalid due to a character conversion error. |
| SQLSTATE | Contains a return code for the outcome of the most recent execution of an SQL statement. |