ALLBASE/SQL Message Manual (36216-90213)

Chapter 6 189
ALLBASE/SQL Error Messages: 2420-2795
or
you are doing a GROUP BY with a SELECT * and you
have failed to reference all of the columns in the specified
table in the GROUP BY clause.
ACTION Issue the SELECT statement again, specifying only
aggregate functions and columns referenced in the
GROUP BY clause In the case of SELECT *, be sure to
reference all columns produced by the expansion of the *
in the GROUP BY clause.
2706 MESSAGE INSERT/UPDATE/DELETE disallowed on DISTINCT
operation. (DBERR 2706)
CAUSE UPDATE, INSERT, and DELETE operations through a
view are not allowed if the view definition involves a
distinct clause.
ACTION Perform the UPDATE, INSERT, or DELETE operation on
the base table or re-create the view without the
DISTINCT clause.
2707 MESSAGE UPDATE/DELETE disallowed on a cursor
containing a subquery. (DBERR 2707)
CAUSE You attempted to UPDATE or DELETE rows accessed
through a cursor which contained a subquery in its
definition.
ACTION Perform the UPDATE or DELETE only through a cursor
which does not contain a subquery.
2708 MESSAGE UPDATE/DELETE disallowed with subquery
containing
update/delete table. (DBERR 2708)
CAUSE You attempted to UPDATE or DELETE through a view or
with a search condition containing a subquery which
references the target table.
ACTION Perform the UPDATE or DELETE only through views
with search conditions which do not reference the target
table in any subqueries.
2709 MESSAGE UPDATE/DELETE disallowed on UNION. (DBERR
2709)
CAUSE You attempted to UPDATE or DELETE through a cursor
containing a UNION.
ACTION Perform the UPDATE or DELETE only through cursors
not containing UNIONs.
2710 MESSAGE INSERT or FORMAT II INSERT disallowed on a
view referencing
the insert table in a subquery. (DBERR 2710)