Troubleshooting guide

February 2006 221
203 An illegal integer has been found in
the statement.
Integers must be whole numbers from -2,147,483,647
to 2,147,483,647. Verify that you have not included a
number with a fractional portion or a number outside
the acceptable range. Verify also that you have not
inadvertently entered a letter in place of a number (for
example, 125p3 instead of 12503).
204 An illegal floating-point number has
been found in the statement.
Verify that you have not inadvertently entered a letter in
place of a number (for example, 125p3 instead of
125.03).
206 The specified table name is not in
the database.
Verify the spelling of the table name in your statement.
217 Column column-name not found in
any table in the query.
Correct the spelling of the database item and ensure
that the item exists in the database table. Verify for the
presence of required commas and quotes.
219 Wildcard matching may not be used
with noncharacter types.
Wildcards (*, ?) and characters enclosed in brackets [ ]
can be used only with CHAR data types. Verify the data
type for the offending column.
220 There is no “FROM” clause in the
query.
You must include a FROM clause in the query. Verify
that you do not have an illegal character ($, #, &, and
so on) or a CONTROL character in the line prior to the
FROM keyword.
223 Duplicate table name table-name in
the FROM clause.
Remove the redundant table name from the statement
or use an alias to rename one of the tables.
228 Cannot have negative characters. Verify that you have not included a negative CHAR
data type (for example, -a or -p) in your statement.
278 Too many ORDER BY columns;
maximum is eight.
Reduce the number of columns included in the ORDER
BY clause to eight or fewer.
280 Total size of ORDER BY columns
exceeds 120 bytes.
Reduce the number of columns included in the ORDER
BY clause so that the total number of characters is
fewer than or equal to 120 (perhaps delete a CHAR
column of 30 or more characters).
282 Found a quote for which there is no
matching quote.
Verify that all quoted strings are properly terminated
with a quote.
284 A subquery has not returned
exactly one value.
Verify data for the subquery. Restructure the subquery
by adding more components in the WHERE clause so
that only one value is returned.
297 The SELECT list may not contain a
subquery.
Remove the subquery from the SELECT list in the
statement.
Error Description Solution