Message Reference

Chapter 12. 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
0F	Invalid Token	Table 9
21	Cardinality Violation	Table 10
22	Data Exception	Table 11
23	Constraint Violation	Table 12
24	Invalid Cursor State	Table 13
25	Invalid Transaction State	Table 14
26	Invalid SQL Statement Identifier	Table 15
28	Invalid Authorization Specification	Table 16
2D	Invalid Transaction Termination	Table 17
2E	Invalid Connection Name	Table 18
34	Invalid Cursor Name	Table 19
38	External Function Exception	Table 20
39	External Function Call Exception	Table 21
40	Transaction Rollback	Table 22
42	Syntax Error or Access Rule Violation	Table 23
44	WITH CHECK OPTION Violation	Table 24
46	Java DDL	Table 25
51	Invalid Application State	Table 26
54	SQL or Product Limit Exceeded	Table 27
55	Object Not in Prerequisite State	Table 28
56	Miscellaneous SQL or Product Error	Table 29
57	Resource Not Available or Operator Intervention	Table 30
58	System Error	Table 31

[ DB2 List of Books | Search the DB2 Books ]