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
|
