ALLBASE/SQL Message Manual (36216-90213)

Chapter 4 107
ALLBASE/SQL Error Messages: 746-2100
additional information on data data types.
1023 MESSAGE Duplicate tables in the FROM list. (DBERR
1023)
CAUSE You specified the same table twice in the FROM clause of
the statement. The statement was not executed.
ACTION Issue the SELECT statement again, specifying each table
only once. Refer to the ALLBASE/SQL Reference Manual
for additional information on the SELECT statement.
1024 MESSAGE Table in expression not in FROM list. (DBERR
1024)
CAUSE You used a column from a table in an expression, but you
did not include the table in the FROM clause.
ACTION Issue the SELECT statement again adding the specified
table to the FROM list or remove the expression
referencing the table before executing the command again.
Refer to the ALLBASE/SQL Reference Manual for
additional information on the SELECT statement.
1025 MESSAGE Number of columns does not match number of
values. (DBERR 1025)
CAUSE The number of columns you specified in an INSERT
statement does not match the number of values in the
VALUES clause.
ACTION Issue the INSERT statement again, specifying the same
value in the VALUES clause and the number of columns
specified. Refer to the ALLBASE/SQL Reference Manual
for additional information on the INSERT statement.
1026 MESSAGE Numeric value too long. (DBERR 1026)
CAUSE You attempted to enter a TID field greater than 80 digits
long.
ACTION Shorten any TID field greater than 80 digits and reissue
the statement.
1027 MESSAGE Float precision specified not in valid range.
(DBERR 1027)
CAUSE You specified a precision outside the range 1 - 53 in a
column defined to be of type FLOAT(precision).
ACTION Check your syntax and reissue the command with a legal
precision value.
1028 MESSAGE UPDATE not allowed with ORDER BY. (DBERR
1028)
CAUSE You specified both an UPDATE clause and an ORDER BY
clause in the DECLARE CURSOR statement.