| SQLCODE Variable | Description |
|---|---|
| negative | An error condition has been reported. |
| positive | A warning has occurred. |
If no exception or error condition is encountered during processing, PP2 sets the SQLCODE variable to zero.
SQLCODE is defined as a 32-bit signed integer variable:
int SQLCODE;
Some exception conditions are not reflected in the SQLCODE.
Data truncation on assignment of a value to a host variable is returned in SQLCODE(+902).
The application should always check the SQLCODE variable upon return from processing an executable statement. Use the WHENEVER statement as one method to accomplish SQLCODE checking.
A SQLCODE and a SQLSTATE variable can be defined for the same compilation unit. Both contain valid result codes.
For more information, see Teradata Vantage™ - SQL Stored Procedures and Embedded SQL, B035-1148.