Message Reference

SQLSTATE Messages

This section lists the SQLSTATEs and their meaning. The SQLSTATEs are grouped by class code; for subcodes, see the corresponding tables.

Table 1. SQLSTATE Class Codes

Class Code	Meaning	For subcodes, refer to...
00	Unqualified Successful Completion	Table 2
01	Warning	Table 3
02	No Data	Table 4
07	Dynamic SQL Error	Table 5
08	Connection Exception	Table 6
09	Triggered Action Exception	Table 7
0A	Feature Not Supported	Table 8
0D	Invalid Target Type Specification	Table 9
0F	Invalid Token	Table 10
0K	Invalid RESIGNAL Statement	Table 11
20	Case Not Found for CASE Statement	Table 12
21	Cardinality Violation	Table 13
22	Data Exception	Table 14
23	Constraint Violation	Table 15
24	Invalid Cursor State	Table 16
25	Invalid Transaction State	Table 17
26	Invalid SQL Statement Identifier	Table 18
28	Invalid Authorization Specification	Table 19
2D	Invalid Transaction Termination	Table 20
2E	Invalid Connection Name	Table 21
34	Invalid Cursor Name	Table 22
38	External Function Exception	Table 23
39	External Function Call Exception	Table 24
3B	Invalid SAVEPOINT	Table 25
40	Transaction Rollback	Table 26
42	Syntax Error or Access Rule Violation	Table 27
44	WITH CHECK OPTION Violation	Table 28
46	Java DDL	Table 29
51	Invalid Application State	Table 30
54	SQL or Product Limit Exceeded	Table 31
55	Object Not in Prerequisite State	Table 32
56	Miscellaneous SQL or Product Error	Table 33
57	Resource Not Available or Operator Intervention	Table 34
58	System Error	Table 35