D. Settings for Strict ANSI Compliance : ESQL Preprocessor Flags : -sqlcode
 
Share this page                  
-sqlcode
The -sqlcode ESQL preprocessor flag incorporates the declaration required for the ANSI standard SQLCODE status variable. For details about SQLCODE, see SQLCODE and SQLSTATE in the chapter "Working with Transactions and Error Handling" and the ANSI standard. SQLCODE is a deprecated ANSI feature -SQLSTATE is the recommended status variable. For details, see the Embedded SQL Companion Guide.
ANSI/ISO Entry SQL-92
Specify -sqlcode if your program declares SQLCODE outside of an SQL declare section. This flag is optional if your source code declares SQLCODE in a declare section. To see SQLCODE, your source code must also contain an include sqlca statement. (Some host languages require the -sqlcode flag regardless of where SQLCODE is declared. For details, see the Embedded SQL Companion Guide.)
Ingres Default
There is no default. Ingres provides other proprietary methods for checking program status and error conditions. For details, see the chapter "Working with Transactions and Error Handling." If your source code declares a variable named SQLCODE that is not intended to be used for the ANSI status variable, specify the ‑nosqlcode flag to prevent Ingres from writing ANSI status information into the variable.