SQL CODES
CODEÂ Â Â Â Â Â Â Â Â CAUSE
- +100 Â Â Â Â Â Â Â Â Â No rows fetched.
 - -102          String constant is too long
 - -117          The number of values you are trying to INSERT does not match the number of columns.
 - -180/-181    Bad data in Date/Time/Timestamp
 - -199           Illegal use of specified keyword
 - -204           Object not defined in DB2
 - -205/-206    Column Specified does not exist
 - +304          Value can not be assigned to the host variable because it is out of range.
 - -305           Null indicator missing
 - -311           VARCHAR Insert or update failed (-LEN field was not set right with the data length.
 - -501           Cursor not opened for FETCH
 - -502          Trying to open an already opened cursor
 - -503           Updating column which needs to be specified in FOR UPDATE OF
 - -530           Referential integrity prevents the INSERT/UPDATE
 - -532/-536    Referential integrity (DELETE RESTRICT rule) prevents the DELETE
 - -545           Check constraint prevents the INSERT/UPDATE
 - +802         null indicator was set to -2 because an arithmetic statement didn’t work
 - -803           Duplicate key on insert or update
 - -805           DBRM or package not found in plan
 - -811           More than one row retrieved in Select statement
 - -904           Resource is Unavailable.
 - -911         Deadlock occurred. Rollback has been done
 - -913           Deadlock. No Rollback
 - -922           Authorization Failure