SQL State error codes

Sybase IQ supports the SQLSTATE error code defined by SQL/92.

Each SQL State (SQLSTATE) value is a 5-character string containing a 2-character class followed by a 3-character subclass. Each character can be one of the uppercase letters A through Z or the digits 0 through 9. A class that begins with A through H or 0 through 4 has been defined by the ANSI standard; other classes are implementation defined. Similarly, subclasses of standard classes that start with the same characters (A-H, 0-4) are standard. The subclass 000 always means that no subclass code is defined. The most common SQLSTATE value is 00000, which indicates successful completion.

Sybase IQ SQL Conventions:

Implementation-defined classes and subclasses start with 'Q'.

Class code Error type Range
QD dblib errors 0 - 999
QF dflib errors 1000 - 1999
QG gexlib errors 2000 - 2999
QH hqmlib errors 3000 - 3999
QM monlib errors 4000 - 4999
QT optlib errors 5000 - 5999
QB oslib errors 6000 - 6999
QR rwlib errors 7000 - 7999
QN saintlib errors 8000 - 8999
QS slib errors 9000 - 9999
QX stcxtlib errors 10000 -10999
QV vplib errors 11000 -11999
QU backup errors 12000 -12999
QC misc db errors 13000 -13999
QI inclib errors 14000 -14999

Finding information about an error

To simplify navigation, messages are grouped by range. To locate information about a specific error, click on the appropriate branch of the navigation tree, then choose the page that contains the error code.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com