Class
|
Subclass
|
Meaning
|
| 00 |
000 |
Successful completion |
| 01 |
000 |
Warning |
| 01 |
002 |
Disconnect error |
| 01 |
003 |
Null value eliminated in set function |
| 01 |
004 |
String data, right truncation |
| 01 |
005 |
Insufficient item descriptor areas |
| 01 |
006 |
Privilege not revoked |
| 01 |
007 |
Privilege not granted |
| 01 |
008 |
Implicit zero-bit padding |
| 01 |
009 |
Search condition too long for information schema |
| 01 |
00A |
Query expression too long for information schema |
| 01 |
00B |
Default option too long for information schema |
| 02 |
000 |
No data |
| 07 |
000 |
Dynamic SQL error |
| 07 |
001 |
using clause does not match dynamic parameter specifications |
| 07 |
002 |
using clause does not match target specification |
| 07 |
003 |
Cursor specification cannot be executed |
| 07 |
004 |
using clause required for dynamic parameters |
| 07 |
005 |
Prepared statement is not a cursor specification |
| 07 |
006 |
Restricted data type attribute violation |
| 07 |
007 |
using clause required for result fields |
| 07 |
008 |
Invalid descriptor count |
| 07 |
009 |
Invalid descriptor index |
| 07 |
00F |
Undefined DATETIME_INTERVAL_CODE |
| 08 |
000 |
Connection exception |
| 08 |
001 |
Client unable to establish connection |
| 08 |
002 |
Connection name in use |
| 08 |
003 |
Connection does not exist |
| 08 |
004 |
Server rejected the connection |
| 08 |
006 |
Connection failure |
| 09 |
000 |
Triggered action exception |
| 0A |
000 |
Feature not supported |
| 0K |
000 |
Resignal when handler not active |
| 20 |
000 |
Case not found for a case statement |
| 21 |
000 |
Cardinality violation |
| 22 |
000 |
Data exception |
| 22 |
001 |
String data, right truncation |
| 22 |
002 |
Null value, no indicator parameter |
| 22 |
003 |
Numeric value out of range |
| 22 |
005 |
Error in assignment |
| 22 |
006 |
Invalid interval format |
| 22 |
007 |
Invalid datetime format |
| 22 |
008 |
Datetime field overflow |
| 22 |
011 |
Substring error |
| 22 |
012 |
Division by zero |
| 22 |
015 |
Interval field overflow |
| 22 |
018 |
Invalid character value for cast |
| 22 |
019 |
Invalid escape character |
| 22 |
023 |
Invalid parameter value |
| 22 |
024 |
Unterminated C string |
| 22 |
025 |
Invalid escape sequence |
| 22 |
026 |
String data, length mismatch |
| 22 |
027 |
Trim error |
| 23 |
000 |
Integrity constraint violation |
| 24 |
000 |
Invalid cursor state |
| 25 |
000 |
Invalid transaction state |
| 26 |
000 |
Invalid SQL statement name |
| 27 |
000 |
Triggered data change violation |
| 28 |
000 |
Invalid authorization specification |
| 2E |
000 |
Invalid connection name |
| 2F |
000 |
SQL routine exception |
| 2F |
003 |
Prohibited SQL-statement attempted |
| 2F |
005 |
Function executed no return statement |
| 33 |
000 |
Invalid SQL descriptor name |
| 34 |
000 |
Invalid cursor name |
| 35 |
000 |
Invalid condition number |
| 3C |
000 |
Ambiguous cursor name |
| 40 |
000 |
Transaction rollback |
| 40 |
001 |
Serialization failure |
| 40 |
003 |
Statement completion unknown |
| 42 |
000 |
Syntax error or access rule violation |
| 44 |
000 |
WITH CHECK OPTION violation |
| 45 |
000 |
Unhandled user-defined exception |
| S1 |
000 |
General error |
| S1 |
001 |
Memory allocation failure |
