ALLBASE/SQL Message Manual (36216-90213)
169
6 ALLBASE/SQL Error Messages:
2420-2795
2420 MESSAGE INSERT rejected: Values do not match number
of columns. (DBERR 2420)
CAUSE The number of values in the INSERT statement exceeded
the number of columns in the INSERT list
or
the number of select list items did not match the number
of columns in the insert list.
ACTION Issue the INSERT statement again, specifying a valid
number of columns. Use the INFO command to get a list of
columns in the table.
2421 MESSAGE Column number exceeds number of SelectList
items. (DBERR 2421)
CAUSE The ORDER BY clause contained a number greater than
the number of select list items.
ACTION Issue the SELECT statement again, specifying no more
columns in the ORDER BY clause than in the select list.
Refer to the ALLBASE/SQL Reference Manual for
additional information on the SELECT statement.
2422 MESSAGE Range violation on value !. Valid range is !
- !. (DBERR 2422)
CAUSE The source constant number in the query was out of its
valid range
or
a host variable was not deļ¬ned
or
one of the values in a format node was out of range.
ACTION Correct your query so that the source constant is within
the valid range
or
make sure that the host variable has been declared
or