ALLBASE/SQL Message Manual (36216-90213)

106 Chapter4
ALLBASE/SQL Error Messages: 746-2100
CAUSE The owner name you specified in the command(s) exceeds
the 20-character maximum allowed for basic names.
ACTION Issue the command again, specifying a valid owner name.
Refer to the ALLBASE/SQL Reference Manual for
naming conventions.
1017 MESSAGE Column number for ORDER BY must be greater
than 0. (DBERR 1017)
CAUSE The column number in the ORDER BY clause was less
than or equal zero. The SELECT statement was aborted.
ACTION Issue the SELECT statement again, specifying a column
number greater than zero.
1018 MESSAGE Aggregate functions not allowed in the WHERE
clause. (DBERR 1018)
CAUSE You specified an aggregate function in the WHERE clause
of the query.
ACTION Move the boolean expression using the aggregate from the
WHERE clause to the HAVING clause. Refer to the
ALLBASE/SQL Reference Manual for additional
information on aggregates.
1019 MESSAGE Parameters not supported yet. (DBERR 1019)
CAUSE You included a clause which is not valid for the specified
command.
ACTION Refer to the ALLBASE/SQL Reference Manual for
additional information on the specified command.
1020 MESSAGE Statement not allowed in PREPARE statement.
(DBERR 1020)
CAUSE You included a statement in the PREPARE statement
which is not valid.
ACTION Refer to the ALLBASE/SQL Reference Manual for
additional information on the PREPARE statement.
1021 MESSAGE Semantic error. (DBERR 1021)
CAUSE You included a clause which is not valid for the specified
statement.
ACTION Refer to the ALLBASE/SQL Reference Manual for
additional information on the statement.
1022 MESSAGE Constant number is out of representable
range. (DBERR 1022)
CAUSE The constant you gave in an INSERT statement or as part
of an expression is too large.
ACTION Refer to the ALLBASE/SQL Reference Manual for