CHAPTER 6 Adaptive Server Error Messages
757
Server Error Messages 1 - 199
Number Severity Text and Explanation
21 10 WARNING - Fatal Error %ld occurred at %S_DATE. Please note the error and time,
and contact a user with System Administrator (SA) authorization.
Explanation: This is an informational message. Unless otherwise specified, no action
is required. Contact your System Administrator about any warning issued in the
message.
101 15 Line %d: SQL syntax error.
Explanation: Command failed. Check syntax and semantics.
102 15 Incorrect syntax near `%.*s'.
Explanation: Refer to the writeup for Error 102.
103 15 The %S_MSG that starts with `%.*s' is too long. Maximum length is %d.
Explanation: Command failed. Check syntax and sema ntics. Re write the co mmand to
satisfy the condition indicated in the message.
104 15 Order-by items must appear in the select-list if the statement contains set operators.
Explanation: Command failed. Check syntax and sema ntics. Re write the co mmand to
satisfy the condition indicated in the message.
105 15 Unclosed quote before the character string `%.*s'.
Explanation: Command failed. Check syntax and sema ntics. Re write the co mmand to
satisfy the condition indicated in the message.
106 16 Too many table names in the query. The maximum allowable is %d.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
107 15 The column prefix `%.*s' does not match with a table name or alias name used in the
query. Either the table is not specified in the FROM clause or it has a correlation name
which must be used instead.
Explanation: Refer to the writeup for Error 107.
108 15 The order-by position number `%ld' is out of range of the number of items in the select-
list.
Explanation: Command failed. Check syntax and sema ntics. Re write the co mmand to
satisfy the condition indicated in the message.
109 15 There are more columns in the INSERT statement than values specified in the VALUES
clause. The number of values in the VALUES clause must match the number of columns
specified in the INSERT statement.
Explanation: Command failed. Check syntax and sema ntics. Re write the co mmand to
satisfy the condition indicated in the message.