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 |
|---|---|---|---|---|---|
| QTA16 | Error | 20170 | -1005016L | "Aggregate functions are not allowed in a GROUP BY clause %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA17 | Error | 20171 | -1005017L | "You cannot DELETE from a join virtual table. (%2) %1" | If this message occurs, it means that the user has tried to DELETE from a join virtual table. This is not permitted. Click here for a list of possible parameters and odbc states. |
| 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. |
| 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. |
| QUA03 | Error | 20926 | -1012003L | "You must do a full backup before doing an incremental backup. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QUA04 | Error | 20927 | -1012004L | "You cannot do incremental backups with this release. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |