15.10 - SQLCODE Variable - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Preprocessor2 for Embedded SQL
Programming Reference

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.