Class
|
Subclass
|
Meaning
|
00
|
000
|
Success
|
01
|
000
|
Success with 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
|
02
|
000
|
No data
|
07
|
000
|
Dynamic SQL error
|
07
|
001
|
using-clause does not match dynamic variables
|
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
|
006
|
Restricted data type attribute violation
|
07
|
007
|
using-clause required for result fields
|
07
|
008
|
Invalid descriptor count
|
07
|
009
|
Invalid descriptor index
|
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
|
08
|
S01
|
Communication link failure
|
0A
|
000
|
Feature not supported
|
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 variable
|
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
|
027
|
Trim error
|
23
|
000
|
Integrity constraint violation
|
24
|
000
|
Invalid cursor state
|
25
|
000
|
Invalid transaction state
|
26
|
000
|
Invalid SQL statement identifier
|
28
|
000
|
Invalid authorization specification
|
2E
|
000
|
Invalid connection name
|
33
|
000
|
Invalid SQL descriptor name
|
34
|
000
|
Invalid cursor name
|
35
|
000
|
Invalid exception number
|
37
|
000
|
Syntax error or access violation in PREPARE or EXECUTE IMMEDIATE
|
3C
|
000
|
Ambiguous cursor name
|
40
|
000
|
Transaction rollback
|
40
|
001
|
Serialization failure
|
40
|
003
|
Statement completion unknown
|
42
|
000
|
Syntax error or access violation
|
44
|
000
|
WITH CHECK OPTION violation
|
45
|
000
|
Unhandled user-defined exception
|
S1
|
000
|
General error
|
S1
|
001
|
Memory allocation failure
|
