Messages on this page are sorted by Sybase error code. Locate the appropriate code in the table below, and click the link for a full description of the message.
| Number | Msg Type | SQL State | SQL Code | Message | Possible Cause |
|---|---|---|---|---|---|
| 20156 | Error | QTA02 | -1005002L | "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. |
| 20157 | Error | QTA03 | -1005003L | "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. |
| 20158 | Error | QTA04 | -1005004L | "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. |
| 20159 | Error | QTA05 | -1005005L | "Deleting from views is not supported. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 20160 | Error | QTA06 | -1005006L | "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. |
| 20162 | Error | QTA08 | -1005008L | "Sybase IQ does not support nested aggregations. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 20163 | Error | QTA09 | -1005009L | "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. |
| 20164 | Error | QTA10 | -1005010L | "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. |
| 20165 | Error | QTA11 | -1005011L | "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. |
| 20166 | Error | QTA12 | -1005012L | "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. |
| 20167 | Error | QTA13 | -1005013L | "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. |
| 20168 | Error | QTA14 | -1005014L | "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. |
| 20169 | Error | QTA15 | -1005015L | "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. |
| 20170 | Error | QTA16 | -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. |
| 20171 | Error | QTA17 | -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. |
| 20172 | Error | QHA00 | -1003000L | "Datatype %2, returned by Client Library, is not valid in Sybase IQ. %1" | Sybase IQ doesn't support a number of datatypes that ASE does (text or image, for example). Refer to documentation for the respective products to see what datatypes are supported. Click here for a list of possible parameters and odbc states. |
| 20173 | Error | QHA01 | -1003001L | "Cannot convert to Sybase IQ datatype: %2 from Client Library datatype %3. %1" | Error converting CSLIB datatype to IQ datatype. Click here for a list of possible parameters and odbc states. |
| 20174 | Error | QHA02 | -1003002L | "CtLibrary Error: %2, Severity: %3, Origin: %4, Layer: %5\nError Message: %6\nOS Error: %7, OS Message: %8. %1" | General CTLIB/CSLIB error message. Refer to the CTLibrary/CSLibrary for error information. Click here for a list of possible parameters and odbc states. |
| 20175 | Error | QHA03 | -1003003L | "Adaptive Server Error: %2, Severity: %3, State: %4, Line: %5\nServer Name: %6, Procedure Name: %7\nError Message: %8. %1" | ASE error. Refer to the ASE error documentation for information regarding the error. Click here for a list of possible parameters and odbc states. |
| 20176 | Error | QHA04 | -1003004L | "COMPUTE values cannot be used in attached database queries. %1" | Sybase IQ doesn't process COMPUTE clauses. Click here for a list of possible parameters and odbc states. |