SQL Codes › Overview

Overview

If you are using the CA Datacom/DB SQL Preprocessor or the Interactive SQL Service Facility, errors can generate non-SQL return codes or messages as described in the CA Datacom/DB Message Reference Guide.

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 Datadictionary Service Facility and you need to check other SQL Communication Area (SQLCA) fields for a specific Datadictionary Service Facility (DSF) return code to determine what caused the error.
• CA Datacom/DB SQL can also pass warning information in the SQLWARN section of the SQLCA.

Your program should print or display all return code information in the SQLCA.

Note: For information about the SQLCA fields, see the CA Datacom/DB SQL User Guide.

The following pages list all of the SQLCODE values and their meanings. For detailed explanations and appropriate user responses for each, see the CA Datacom/DB Message Reference Guide.