ALLBASE/SQL Message Manual (36216-90213)

Chapter 5 145
ALLBASE/SQL Error Messages: 2101-2419
ACTION Re-issue the OPEN command, omitting the KEEP option.
2248 MESSAGE The ADVANCE statement is allowed only for a
procedure
cursor. (DBERR 2248)
CAUSE The ADVANCE statement was issued against a cursor, but
the cursor was not defined on an EXECUTE
PROCEDURE statement.
ACTION There is no need for the ADVANCE statement for a
non-procedure cursor. Use the OPEN, FETCH, and
CLOSE statements.
2249 MESSAGE Duplicate column found in update set columns.
(DBERR 2249)
CAUSE The same column was specified twice in the SET clause of
the UPDATE statement.
ACTION Remove one of the duplicate column assignments.
2250 MESSAGE CHECK constraint ! on column ! references
other columns. (DBERR 2250)
CAUSE The named CHECK constraint you defined on a single
column contains references to other columns.
ACTION Either remove the references to the other columns, or
make the check constraint a table level check constraint.
2251 MESSAGE CHECK constraint ! contains host variables.
(DBERR 2251)
CAUSE You defined the named CHECK constraint with host
variables in it.
ACTION Remove the host variable from your CHECK constraint.
2252 MESSAGE CHECK constraint ! contains aggregate
functions. (DBERR 2252)
CAUSE You defined the named CHECK constraint with aggregate
functions in it.
ACTION Remove the aggregate from your CHECK constraint.
2253 MESSAGE CHECK constraint ! contains subqueries.
(DBERR 2253)
CAUSE You defined the named CHECK constraint with
subqueries in it.
ACTION Remove the subquery from your CHECK constraint.
2254 MESSAGE Table CHECK constraint violated. (DBERR 2254)
CAUSE A table CHECK constraint on the target table of the
INSERT or UPDATE was violated during its execution.