ALLBASE/SQL Message Manual (36216-90213)

108 Chapter4
ALLBASE/SQL Error Messages: 746-2100
ACTION Modify the command specifying either an UPDATE clause
or an ORDER BY clause, but not both. Refer to the
ALLBASE/SQL Reference Manual for additional
information on the DECLARE CURSOR statement.
1030 MESSAGE Host variables not allowed in CREATE VIEW.
(DBERR 1030)
CAUSE You specified a host variable in the SELECT statement of
the VIEW command.
ACTION Remove the host variable from the command. Refer to the
ALLBASE/SQL Reference Manual for additional
information on the CREATE VIEW command and to the
appropriate ALLBASE/SQL application programming
guide for additional information on host variables.
1031 MESSAGE Host variables not allowed in the command to
be PREPAREd. (DBERR 1031)
CAUSE You specified a host variable in the PREPARE statement.
ACTION Remove the host variable and issue the command again.
Refer the ALLBASE/SQL Reference Manual for
additional information on the PREPARE statement and to
the appropriate ALLBASE/SQL application programming
guide for additional information on host variables.
1032 MESSAGE Aggregate function can not be nested. (DBERR
1032)
CAUSE The aggregate function you specified in the SELECT
statement contained an aggregate function.
ACTION Issue the command again without nesting aggregate
functions. Refer to the ALLBASE/SQL Reference Manual
for additional information on the SELECT statement.
1038 MESSAGE Two log and file names needed if DUAL LOG.
(DBERR 1038)
CAUSE You specified only one log name and/or file name in the
START DBE NEW or you specified a START DBE
NEWLOG statement and DUAL LOG in the LOG clause.
ACTION Issue the command again, specifying two log and file
names. Refer to the ALLBASE/SQL Reference Manual for
additional information on the START DBE NEW and
START DBE NEWLOG statements.
1039 MESSAGE Number of columns must match number of host
variables or dynamic parameters. (DBERR 1039)
CAUSE The number of host variables did not match the number of
columns or dynamic parameters in the INSERT
statement.