ASE Error Message (171 – 199)

Number	Severity	Explanation
171	15	Can't use SELECT INTO in Browse Mode. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
172	15	Can't use HOLDLOCK in Browse Mode Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
173	15	The definition for column `%.*s' must include a datatype. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
174	15	The function `%.*s' requires %d arguments. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
175	15	Functions may only be nested to level %d. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
176	15	Function `%.*s' is not yet implemented. Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
177	15	%s cannot create a temporary object (with `#' as the first character name. Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
178	15	A RETURN statement with a return status may only be used in a SQL stored procedure. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
179	15	Can't use the OUTPUT option when passing a constant to a stored procedure. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
180	15	There are too many parameters in this CREATE PROCEDURE statement. The maximum number is %d. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
181	15	Can't use the OUTPUT option in a DECLARE statement. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
182	15	Table and column names must be supplied for the READTEXT or WRITETEXT utility. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
183	15	The scale (%d) for column `%.*s' must be within the range %d to %d. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
184	15	Invalid money datatype specification for column `%.*s'. Only money(19/4) is allowed for non-external tables. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
185	15	Data stream is invalid for WRITETEXT command in bulk form. Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
186	15	Data stream missing from WRITETEXT command. Explanation: Command failed. Check the syntax of the WRITETEXT command.
187	15	Odd number of bytes in IMAGE data. Explanation: While inserting text/image data an upper limit on the send may have been reached. Check the data sent and consider using ct_command or other alternative.
188	15	Can't specify a log-device in a CREATE DATABASE statement without also specifying at least one non-log-device. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
189	15	Function `%.*s' requires %d to %d arguments. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
190	15	Can not update the global variable `%.*s'. Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
191	15	Some part of your SQL statement is nested too deeply. Please re-write the query or break it up into smaller queries. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
192	15	Can't create a view inside a stored procedure. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
193	15	The object or column name starting with `%.*s' is too long. The maximum length is %d characters. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
195	15	`%.*s' is not a recognized %S_MSG. Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
196	15	SELECT INTO must be the first query in a SQL statement containing set operators. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
197	15	WITH CHECK OPTION is not allowed in the definition of a union view. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
198	15	Browse mode is invalid for statements containing set operators. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
199	15	An INSERT statement may not contain a SELECT statement that assigns values to a variable. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.