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.
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 |