ALLBASE/SQL Message Manual (36216-90213)

194 Chapter6
ALLBASE/SQL Error Messages: 2420-2795
CAUSE You issued an UPDATE or DELETE statement with a
CURRENT OF CURSOR clause without preceding it with
a FETCH statement or you terminated the transaction
between the FETCH and DELETE or UPDATE statement.
ACTION A FETCH statement must precede any DELETE or
UPDATE WHERE CURRENT operation within the
transaction.
2757 MESSAGE Update column list not in cursor update
column list. (DBERR 2757)
CAUSE You tried to update a column which was not specified when
the cursor was declared.
ACTION A column must be listed in the DECLARE CURSOR
statement before an update operation can be performed on
that column.
2758 MESSAGE Update table different from cursor table.
(DBERR 2758)
CAUSE You tried to update a table which was not specified in the
DECLARE CURSOR statement.
ACTION A table must be listed in the DECLARE CURSOR
statement before it can be updated using the UPDATE
statement with a CURRENT OF CURSOR clause.
2759 MESSAGE Cursor has no current tuple. (DBERR 2759)
CAUSE You issued an UPDATE or DELETE statement with a
CURRENT OF CURSOR clause when the current tuple
had already been deleted.
ACTION Modify your application so that no UPDATE or DELETE
WHERE CURRENT is attempted once the current tuple
has been deleted.
2760 MESSAGE Null value detected and indicator variable
not declared OR attempted
to put null value into non-null column or
result. (DBERR 2760)
CAUSE A SELECT or FETCH statement had no corresponding
indicator variable and a null value was fetched for an item
or
you attempted to put a null value into a non-null column
using the INSERT or UPDATE statement by setting the
indicator variable to a negative number.
or
You specified NOT NULL for a procedure result and a null
value was fetched.