Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1005009L | Error | 20163 | QTA09 | "Cannot perform an aggregate function on a column from a table not declared in the same query. %2, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005010L | Error | 20164 | QTA10 | "The field '%2' is not unique and needs to be qualified, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005011L | Error | 20165 | QTA11 | "There are two tables named '%2'. Please specify an alias for one of them. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005012L | Error | 20166 | QTA12 | "The field '%2' specified in the query cannot be found, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005013L | Error | 20167 | QTA13 | "The FROM clause must have at least one table identifier %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005014L | Error | 20168 | QTA14 | "Non-space text found after ending quote character for an enclosed field. %1" | Non-space text found after ending quote character for an enclosed field. Click here for a list of possible parameters and odbc states. |
| -1005015L | Error | 20169 | QTA15 | "The optimizer was unable to find a query plan that avoided cartesian product joins larger than the Max_Cartesian_Result setting %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005016L | Error | 20170 | QTA16 | "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. |
| -1005017L | Error | 20171 | QTA17 | "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. |
| -1005018L | Error | 20989 | QTA18 | "Illegal ORDER BY item %2, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005019L | Error | 21060 | QTA19 | "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. |
| -1005020L | Error | 21062 | QTA20 | "Only single-table updates are supported by Sybase IQ" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005021L | Error | 21063 | QTA21 | "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. |
| -1005022L | Error | 21066 | QTA22 | "Aggregate not valid in update set-item expression." | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005023L | Error | 21073 | QTA23 | "Unmatched number of select list items in union" | Cube message here Click here for a list of possible parameters and odbc states. |
| -1005024L | Error | 21074 | QTA24 | "Estimate number: %2 exceed the DEFAULT_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. |
| -1005025L | Error | 21089 | QTA25 | "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. |
| -1005026L | Error | 21090 | QTA26 | "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. |
| -1005027L | Error | 21091 | QTA27 | "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. |
| -1005028L | Error | 21092 | QTA28 | "Syntax error - %2. %1" | location of the exception the details of syntax error Click here for a list of possible parameters and odbc states. |