SQLCODE contains a negative value when an error condition is reported. A positive value indicates that 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:
Definition: 01 SQLCODE PIC S9(9) <comp>;
Where <comp> is COMP-5 for MF COBOL and COMP for all other COBOL compilers.
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.