SQL Codes

SQL Codes

The SQL Manager passes a value to the SQLCODE field of the SQL Communications Area after each SQL statement is processed during preprocessing or during program execution. Most SQLCODE values indicate that the error was detected within the SQL Manager. These have negative values. If no error is indicated, the value is zero. If the message is a warning, the code has a positive value.

Two special cases are indicated when the values -117 or -118 are placed in the SQLCODE field.

• If SQLCODE contains -117, this indicates the error was detected by CA Datacom/DB and you need to check other SQL Communication Area (SQLCA) fields for the internal and/or external CA Datacom/DB return code to determine what action you should take.
• If SQLCODE contains -118, this indicates the error was detected by the CA Datacom Datadictionary Service Facility and you need to check other SQL Communication Area (SQLCA) fields for a specific CA Datacom Datadictionary Service Facility (DSF) return code to determine what caused the error.
• CA Datacom/DB SQL may also pass warning information in the SQLWARN section of the SQLCA.

Your program should print or display all return code information in the SQLCA. For information about the SQLCA fields, see the CA Datacom/DB SQL User Guide.

An SQLSTATE status indicator is listed in this chapter for each SQLCODE. For more information, see SQL States.