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