This section provides a listing by numeric SQLCODE of IQ error and warning messages and their descriptions. Negative codes are considered errors; positive codes are warnings. The messages are listed in numerical order as if they are all positive numbers. If a SQLCODE has both a negative and a positive value, the first message listed is “Warning nnn” (the positive SQLCODE), then “Error nnn” (the negative SQLCODE). The SQLCODE 0 indicates successful completion.
Sybase IQ supports the SQLSTATE error code defined by SQL/92. Each 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 error codes are a set of error codes for use by all Sybase products, including Adaptive Server Enterprise. For every Sybase error code returned by Sybase IQ, there is a matching Sybase IQ error code. In many cases Sybase IQ error codes offer a finer level of granularity than their Sybase error code counterparts, thus some Sybase error codes in the following table are non-unique.
Errors with an ODBC state marked “handled by ODBC driver” are not returned to ODBC applications, as the ODBC driver carries out the required actions.
Many of the messages listed in this chapter contain the characters %1, %2 and so on. These characters are replaced by the parameters returned with the error or warning message.
