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 |
|---|---|---|---|---|---|
| -1005002L | Error | 20156 | QTA02 | "Subquery predicates are not supported in the ON clause of outer joins in this release. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005003L | Error | 20157 | QTA03 | "A maximum of one subquery predicate per conjunct is supported in this release. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005004L | Error | 20158 | QTA04 | "Subqueries are allowed only as arguments of comparisons, IN, and EXISTS %2, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005005L | Error | 20159 | QTA05 | "Deleting from views is not supported. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005006L | Error | 20160 | QTA06 | "The target DELETE table must also appear in FROM. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1005008L | Error | 20162 | QTA08 | "Sybase IQ does not support nested aggregations. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -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. |