ALLBASE/SQL Message Manual (36216-90213)

188 Chapter6
ALLBASE/SQL Error Messages: 2420-2795
VARBINARY, LONG BINARY or LONG VARBINARY.
ACTION Change the search string parameter in POSITION/INSTR
to appropriate type.
2700 MESSAGE INSERT/UPDATE/DELETE disallowed on a join.
(DBERR 2700)
CAUSE You attempted to INSERT, UPDATE, or DELETE on a
multiple table view.
ACTION You cannot perform an INSERT, UPDATE, or DELETE on
multi-table views. Refer to the specified command and the
CREATE VIEW statement in the ALLBASE/SQL
Reference Manual for additional information.
2701 MESSAGE INSERT/UPDATE disallowed on virtual column
(!). (DBERR 2701)
CAUSE You attempted to INSERT or UPDATE a computed
column in a view.
ACTION Inserting rows through a view is not allowed if any column
of the view is computed in an arithmetic expression. Refer
to the ALLBASE/SQL Reference Manual for additional
information.
2702 MESSAGE INSERT/UPDATE/DELETE disallowed on group
operation. (DBERR 2702)
CAUSE You attempted to INSERT, UPDATE, or DELETE rows via
a view which contained a GROUP BY clause in its
definition.
ACTION A view definition for UPDATE, DELETE, and INSERT
operations cannot contain a GROUP BY clause. Refer to
the specified command and the CREATE VIEW statement
in the ALLBASE/SQL Reference Manual for additional
information.
2703 MESSAGE INSERT/UPDATE/DELETE disallowed on ORDER BY.
(DBERR 2703)
CAUSE You attempted to declare a cursor containing both an
ORDER BY clause and a FOR UPDATE clause, or you
attempted an UPDATE or DELETE WHERE CURRENT
on a cursor containing an ORDER BY clause.
ACTION Remove the ORDER BY from the cursor if updates and/or
deletes are to be performed with it, or remove the FOR
UPDATE clause from the cursor.
2705 MESSAGE Illegal reference to column ! in group
operation. (DBERR 2705)
CAUSE A column you specified in the select list was not referenced
in the GROUP BY clause of the SELECT statement.