IBM® Informix® Client Software Development Kit, Version 4.10
Fields of the sqlca structure
The sqlca structure is defined in the sqlca.h header file. The IBM® Informix® ESQL/C preprocessor automatically includes the sqlca.h header file in the Informix ESQL/C program.
The following table illustrates the fields of the sqlca structure.
| Field | Type | Value | Value description |
|---|---|---|---|
| sqlcode | int4 | 0 | Indicates success. |
| >=0, < 100 | After a DESCRIBE statement, represents the type of SQL statement that is described. | ||
| 100 | After a successful query that returns no rows, indicates the NOT FOUND condition. NOT FOUND can also occur in an ANSI-compliant database after an INSERT INTO/SELECT, UPDATE, DELETE, or SELECT... INTO TEMP statement fails to access any rows. For more information, see NOT FOUND in SQLSTATE. | ||
| <0 | Error code. | ||
| sqlerrm | character (72) or character (600) | When working with Informix database servers this field is 72 characters long and contains the error message parameter. This parameter is used to replace a %s token in the actual error message. If an error message requires no parameter, this field is blank. | |
| sqlerrp | character (8) | Internal use only. | |
| sqlerrd | array of 6 int4s | [0] | After a successful PREPARE statement for a SELECT, UPDATE, INSERT, or DELETE statement, or after a select cursor is opened, this field contains the estimated number of rows affected. |
| [1] | When SQLCODE contains an error code, this
field contains either zero or an additional error code, called the
ISAM error code, that explains the cause of the main error. After a successful insert operation of a single row, this field contains the value of any SERIAL value generated for that row. |
||
| [2] | After a successful multirow insert, update, or
delete operation, this field contains the number of rows that were
processed. After a multirow insert, update, or delete operation that ends with an error, this field contains the number of rows that were successfully processed before the error was detected. |
||
| [3] | After a successful PREPARE statement for a SELECT, UPDATE, INSERT, or DELETE statement, or after a select cursor was opened, this field contains the estimated weighted sum of disk accesses and total rows processed. | ||
| [4] | After a syntax error in a PREPARE, EXECUTE IMMEDIATE, DECLARE, or static SQL statement, this field contains the offset in the statement text where the error was detected. | ||
| [5] | After a successful fetch of a selected row, or a successful insert, update, or delete operation, this field contains the rowid (physical address) of the last row that was processed. Whether this rowid value corresponds to a row that the database server returns to the user depends on how the database server processes a query, particularly for SELECT statements. |
| Field | Type | Value | Value description |
|---|---|---|---|
| sqlwarn | array of 8 characters | sqlwarn0 | Set to W when any other warning field is set to W. If blank, others do not need to be checked. |
| sqlwarn1 | Set to W when the database now open uses a transaction log. | ||
| sqlwarn2 | Set to W when the database now open is ANSI compliant. | ||
| sqlwarn3 | Set to W. | ||
| sqlwarn4 | Set to W when the database server stores the FLOAT data type in DECIMAL form (done when the host system lacks support for FLOAT data types). | ||
| sqlwarn5 | Reserved. | ||
| sqlwarn6 | Set to W when the application is connected to a database server that is running in secondary mode. The database server is a secondary server in a data-replication pair (the database server is available only for read operations). | ||
| sqlwarn7 | Set to W when client DB_LOCALE does not match the database locale. For more information, see the chapter on Informix ESQL/C in the IBM Informix GLS User's Guide. |
| Field | Type | Value | Value description |
|---|---|---|---|
| sqlwarn | array of 8 characters | sqlwarn0 | Set to W when any other warning field is set to W. If blank, other fields in sqlwarn do not need to be checked. |
| sqlwarn1 | Set to W if a column value is truncated when it is fetched into a host variable with a FETCH or a SELECT...INTO statement. On a REVOKE ALL statement, set to W when not all seven table-level privileges are revoked. | ||
| sqlwarn2 | Set to W when a FETCH or SELECT statement returns an aggregate function (SUM, AVG, MIN, MAX) value that is null. | ||
| sqlwarn3 | On a SELECT...INTO, FETCH...INTO, or EXECUTE...INTO statement, set to W when the number of items in the select list is not the same as the number of host variables given in the INTO clause to receive them. On a GRANT ALL statement, set to W when not all seven table-level privileges are granted. | ||
| sqlwarn4 | Set to W after a DESCRIBE statement if the prepared statement contains a DELETE statement or an UPDATE statement without a WHERE clause. | ||
| sqlwarn5 | Set to W following execution of a statement that does not use ANSI-standard SQL syntax (provided the DBANSIWARN environment variable is set). | ||
| sqlwarn6 | Set to W when a data fragment (a dbspace) has been skipped during query processing (when the DATASKIP feature is on). | ||
| sqlwarn7 | Reserved. |