ALLBASE/SQL Message Manual (36216-90213)

Chapter 6 195
ALLBASE/SQL Error Messages: 2420-2795
ACTION Modify your program to include indicator variables with
columns that might contain null values
or
issue the INSERT or UPDATE statement again,
specifying only non-null values for columns created with
the NOT NULL option.
or
drop the procedure and recreate it, either omitting the
NOT NULL option in the WITH RESULT clause, or
modifying the procedure SELECT statements so that no
null values will be retrieved.
2762 MESSAGE Selectlist has ! items and host variable
buffer has !. (DBERR 2762)
CAUSE The number of select list items in a DECLARE CURSOR
or a SELECT statement does not match the number of
host variables in the corresponding FETCH or SELECT
statement or the number of select list items in the
SELECT statement does not match the number of host
variables in the SELECT statement.
ACTION Modify your program so that the number of variables in
the select list or the SELECT statement matches the
number of host variables. Refer to the ALLBASE/SQL
Reference Manual for additional information on these
commands.
2763 MESSAGE DISTINCT within aggregate functions cannot
reference multiple column
names. (DBERR 2763)
CAUSE The SELECT statement contains more than one aggregate
function containing the DISTINCT option and references
more than one column.
ACTION Modify your statement so that it references only one
column. Refer to the ALLBASE/SQL Reference Manual
for additional information on the SELECT statement.
2764 MESSAGE DISTINCT within an aggregate function cannot
reference an expression. (DBERR 2764)
CAUSE The SELECT statement contains an aggregate function
containing the DISTINCT option and references a column
containing computed values.
ACTION Modify your statement so that only raw columns are
referenced. Refer to the ALLBASE/SQL Reference
Manual for additional information on the SELECT
statement.