DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows
SQLSTATEs in the range 46600 to 466ZZ are reserved for the IBM® Data Server Driver for JDBC and SQLJ.
| SQLSTATE class | SQLSTATE | Description |
|---|---|---|
| 01xxx | Warning | |
| 02xxx | No data | |
| 02xxx | 02501 | The cursor position is not valid for a FETCH of the current row. |
| 02xxx | 02506 | Tolerable error |
| 08xxx | Connection exception | |
| 08xxx | 08001 | The application requester is unable to establish the connection. |
| 08xxx | 08003 | A connection does not exist |
| 08xxx | 08004 | The application server rejected establishment of the connection |
| 08xxx | 08506 | Client reroute exception |
| 0Axxx | Feature not supported | |
| 0Axxx | 0A502 | The action or operation is not enabled for this database instance |
| 0Axxx | 0A504 | The feature is not supported by the driver |
| 22xxx | Data exception | |
| 22xxx | 22007 | The string representation of a datetime value is invalid |
| 22xxx | 22021 | A character is not in the coded character set |
| 23xxx | Constraint violation | |
| 23xxx | 23502 | A value that is inserted into a column or updates a column is null, but the column cannot contain null values. |
| 24xxx | Invalid cursor state | |
| 24xxx | 24501 | The identified cursor is not open |
| 28xxx | Authorization exception | |
| 28xxx | 28000 | Authorization name is invalid. |
| 2Dxxx | Invalid transaction termination | |
| 2Dxxx | 2D521 | SQL COMMIT or ROLLBACK are invalid in the current operating environment. |
| 34xxx | Invalid cursor name | |
| 34xxx | 34000 | Cursor name is invalid. |
| 3Bxxx | Invalid savepoint | |
| 3Bxxx | 3B503 | A SAVEPOINT, RELEASE SAVEPOINT, or ROLLBACK TO SAVEPOINT statement is not allowed in a trigger or global transaction. |
| 40xxx | Transaction rollback | |
| 42xxx | Syntax error or access rule violation | |
| 42xxx | 42601 | A character, token, or clause is invalid or missing |
| 42xxx | 42734 | A duplicate parameter name, SQL variable name, cursor name, condition name, or label was detected. |
| 42xxx | 42807 | The INSERT, UPDATE, or DELETE is not permitted on this object |
| 42xxx | 42808 | A column identified in the insert or update operation is not updateable |
| 42xxx | 42815 | The data type, length, scale, value, or CCSID is invalid |
| 42xxx | 42820 | A numeric constant is too long, or it has a value that is not within the range of its data type |
| 42xxx | 42968 | The connection failed because there is no current software license. |
| 57xxx | Resource not available or operator intervention | |
| 57xxx | 57033 | A deadlock or timeout occurred without automatic rollback |
| 58xxx | System error | |
| 58xxx | 58008 | Execution failed due to a distribution protocol error that will not affect the successful execution of subsequent DDM commands or SQL statements |
| 58xxx | 58009 | Execution failed due to a distribution protocol error that caused deallocation of the conversation |
| 58xxx | 58012 | The bind process with the specified package name and consistency token is not active |
| 58xxx | 58014 | The DDM command is not supported |
| 58xxx | 58015 | The DDM object is not supported |
| 58xxx | 58016 | The DDM parameter is not supported |
| 58xxx | 58017 | The DDM parameter value is not supported |