Messages on this page are sorted by SQLSTATE. Locate the appropriate code in the table below, and click the link for a full description of the message.
SQL State | Msg Type | Number | SQL Code | Message | Possible Cause |
---|---|---|---|---|---|
QTA18 | Error | 20989 | -1005018L | "Illegal ORDER BY item %2, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
QTA19 | Error | 21060 | -1005019L | "The update FROM list must match the table-clause exactly" | No additional information available. Click here for a list of possible parameters and odbc states. |
QTA20 | Error | 21062 | -1005020L | "Only single-table updates are supported by Sybase IQ" | No additional information available. Click here for a list of possible parameters and odbc states. |
QTA21 | Error | 21063 | -1005021L | "Sybase IQ does not allow subqueries in update set-items" | No additional information available. Click here for a list of possible parameters and odbc states. |
QTA22 | Error | 21066 | -1005022L | "Aggregate not valid in update set-item expression." | No additional information available. Click here for a list of possible parameters and odbc states. |
QTA23 | Error | 21073 | -1005023L | "Unmatched number of select list items in union" | Cube message here Click here for a list of possible parameters and odbc states. |
QTA24 | Error | 21074 | -1005024L | "Estimate number: %2 exceed the MAX_CUBE_RESULT of GROUP BY CUBE or ROLLUP %1" | location of the exception the estimated total result of hash base cube or rollup Click here for a list of possible parameters and odbc states. |
QTA25 | Error | 21089 | -1005025L | "Query rejected as too complex. After join simplifications there were still %2 tables to be joined, which exceeds the current setting of Max_Join_Enumeration. %1" | The query will take too long to optimize, so it is being rejected Click here for a list of possible parameters and odbc states. |
QTA26 | Error | 21090 | -1005026L | "Update not supported on null supplying side of outer join." | No additional information available. Click here for a list of possible parameters and odbc states. |
QTA27 | Error | 21091 | -1005027L | "An error occurs during unistring conversion - %2. %1" | location of the exception the details of unilib error Click here for a list of possible parameters and odbc states. |
QTA28 | Error | 21092 | -1005028L | "Syntax error - %2. %1" | location of the exception the details of syntax error Click here for a list of possible parameters and odbc states. |
QTA29 | Error | 21143 | -1005029L | "You cannot SELECT from a join virtual table. (%2) %1" | location of the exception the details of syntax error Click here for a list of possible parameters and odbc states. |
QTA30 | Error | 21145 | -1005030L | "Query has an ambiguous table reference between prepare and open cursor (%2). %1" | SA allows a base and temp table to both have the same table name. In some places, such as when a temp table is created in a stored procedure between the describe and open, IQ can find the base table in the describe and the temp table in the open, giving inconsistent results. Click here for a list of possible parameters and odbc states. |
QTA31 | Error | 21217 | -1005031L | "Illegal PARTITION BY item %2, %1" | MARKNEW The specificied column name or ordinal number is not present within the select list. Click here for a list of possible parameters and odbc states. |
QTA32 | Error | 21218 | -1005032L | "Conflicting partitioning requirements were detected in UDF '%2' and SQL '%3', %1" | MARKNEW The partition by specification described by the UDF and contained within the SQL select conflict. Click here for a list of possible parameters and odbc states. |
QTA33 | Error | 21219 | -1005033L | "Conflicting ordering requirements were detected: %2, %1" | MARKNEW The order by specification described by the UDF and contained within the SQL select conflict. Click here for a list of possible parameters and odbc states. |
QTA34 | Error | 21220 | -1005034L | "column is not present in the projection list, %1" | No additional information available.. Click here for a list of possible parameters and odbc states. |
QUA00 | Error | 20923 | -1012000L | "You cannot do a partial restore for database '%2' because it has been updated (%3) since its last backup (%4). %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
QUA01 | Error | 20924 | -1012001L | "There is already a backup or selective restore in progress. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
QUA02 | Error | 20925 | -1012002L | "Unable to write to archive. ('%2') %1" | No additional information available. Click here for a list of possible parameters and odbc states. |