SQL Clearly Explained, 2nd Edition

Appendix B. SQLSTATE Return Codes

This appendix contains a numeric listing of the SQLSTATE return codes specified in the SQL standard (Table B-1). SQLSTATE is a five-character string. The leftmost two characters represent the error class; the rightmost three characters represent the subclass. Because SQLSTATE is a string, an embedded SQL program will need to use a substring function if it needs to separate the two parts of the code.

Table B-1 SQLSTATE return codes

Class	Class definition	Subclass	Subclass definition
00	Successful completion	000	None
01	Warning	000	None
001	Cursor operation conflict
002	Disconnect error
003	Null value eliminated in set function
004	String data, right truncation
005	Insufficient item descriptor area
006	Privilege not revoked
007	Privilege ...