ALLBASE/SQL Message Manual (36216-90213)

146 Chapter5
ALLBASE/SQL Error Messages: 2101-2419
ACTION Identify the constraint violated and determine the proper
value for the INSERT or UPDATE.
2255 MESSAGE View CHECK OPTION constraint violated. (DBERR
2255)
CAUSE A check constraint on the view named for the INSERT or
UPDATE was violated during its execution.
ACTION Identify the view definition violated (under the topmost
WITH CHECK OPTION view) and determine the proper
value for the INSERT or UPDATE.
2256 MESSAGE CHECK constraint ! invalid. (DBERR 2256)
CAUSE The named CHECK constraint will not be executable and
so is not valid.
ACTION Identify the problem with the CHECK constraint by
examining the error or errors prior to this one. Correct the
problem of those errors in order to make the CHECK
constraint executable.
2257 MESSAGE View defined WITH CHECK OPTION contains
non-updatable query. (DBERR 2257)
CAUSE The view definition cannot be part of a WITH CHECK
OPTION since no INSERT or UPDATE can be applied to
the view.
ACTION Either remove the WITH CHECK OPTION clause or
modify the view definition to make it updatable. Refer to
the ALLBASE/SQL Reference Manual for a definition of
updatable views.
2258 MESSAGE !.! (!) is not a procedure cursor. (DBERR
2258)
CAUSE The USING clause was included in a CLOSE cursor
statement, but the cursor was not defined on an
EXECUTE PROCEDURE statement.
ACTION Re-issue the CLOSE statement, omitting the USING
clause, or re-issue the CLOSE statement with the USING
clause, specifying the correct cursor name.
2259 MESSAGE The RESULT option is allowed only for a
procedure returning results. (DBERR 2258)
CAUSE The RESULT option was specified in a DESCRIBE
statement, but the statement described is not an
EXECUTE PROCEDURE statement.
ACTION For statements other than EXECUTE PROCEDURE, the
DESCRIBE RESULT statement is not necessary. If the
sqlmproc field of the SQLDA is 0 after DESCRIBE
OUTPUT, there is no need to DESCRIBE RESULT.