| Number | Severity | Explanation |
|---|---|---|
| 141 | 15 | A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 143 | 15 | A compute-by item was not found in the order-by list. All expressions in the compute-by list must also be present in the order-by list. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 144 | 15 | Cannot use an aggregate in an expression used for the by-list of a GROUP BY clause. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 145 | 15 | A subquery with no aggregate functions may only contain expressions in its GROUP BY clause that are in the select-list. . Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 146 | 15 | Cannot perform an aggregate function on a column from a table not declared in the same subquery. . Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 147 | 15 | An aggregate function may not appear in a WHERE clause unless it is in a subquery that is in a HAVING clause and the column being aggregated is in a table named in a FROM clause outside of the subquery. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 148 | 15 | Incorrect time syntax in time string `%.*s' used with WAITFOR. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 149 | 15 | Time value `%.*s' used with WAITFOR is not a legal value. Check date/time syntax. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 150 | 15 | Both terms of an outer join must contain columns. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 151 | 15 | `%.*s' is an invalid money value. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 152 | 15 | Subqueries that use DISTINCT with a GROUP BY clause are not currently supported. Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action. (This error is not raised in Release 11.0 and higher.) |
| 153 | 16 | Variables/Parameters are not allowed in the ORDER BY clause. Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message. |
| 154 | 15 | %S_MSG is not allowed in %S_MSG. Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action. |
| 155 | 15 | `%.*s' is not a recognized %s option. Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action. |
| 156 | 15 | Incorrect syntax near the keyword `%.*s'. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 158 | 15 | Too many ORDER BY expressions. The maximum is %d. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 159 | 15 | For DROP INDEX – must give both the table and the index name in the form tablename.indexname Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message |
| 160 | 15 | Rule does not contain a variable. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 161 | 15 | Rule contains more than one variable. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 162 | 15 | The select list item identified by the order by number `%ld' is a `*' – rather than a column name. When ordering by column number – a column name must appear in the select list position that corresponds to the order by number. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 163 | 15 | The COMPUTE BY list does not match the ORDER BY list. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 164 | 15 | GROUP BY expressions must refer to column names. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 165 | 16 | Privilege %s may not be GRANTed or REVOKEd. Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context. |
| 166 | 15 | %s does not allow specifying the database name as a prefix to the object name. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
| 167 | 15 | May not create a trigger on a temporary object. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data. |
| 168 | 15 | The %S_MSG `%.*s' is out of the range of machine representation (%d bytes). Explanation: Command failed. Check syntax and semantics. |
| 169 | 15 | Expression `%d' and `%d' in the ORDER BY list are same. Expressions in the ORDER BY list must be unique. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. |
