DB2 SQL Return Codes - SQLCODE

SQLCODE

The SQLCODE field contains the SQL return code. The code can be zero (0), negative or positive.

0 means successful execution. Negative means unsuccessful with an error. An example is -911 which means a timeout has occurred with a rollback. Positive means successful execution with a warning. An example is +100 which means no rows found.

Here is a more comprehensive list of the SQLCODEs for DB2:

Read more about this topic:  DB2 SQL Return Codes