ALLBASE/SQL Message Manual (36216-90213)

190 Chapter6
ALLBASE/SQL Error Messages: 2420-2795
CAUSE You attempted to insert through a view, where the view
contains a subquery which references the same base table
the view is based upon. Such an insert is not allowed.
ACTION Insert directly through the base table, or use a view not
containing subqueries which reference the same table as
the view.
2711 MESSAGE Qualifier !.! (column !) is different from
input table. (DBERR 2711)
CAUSE The table name you specified in the select list or WHERE
clause is different from the table name specified in the
FROM clause of the SELECT statement.
ACTION Issue the SELECT statement again, specifying the same
table name in both the select list or WHERE clause and
the FROM clause. Refer to the ALLBASE/SQL Reference
Manual for additional information on the SELECT
statement.
2712 MESSAGE Hash key columns may not be updated. (DBERR
2712)
CAUSE You tried to update the value of a column included in the
key for a hash.
ACTION DELETE the tuple with the old key column value. Then,
INSERT a new tuple with the new key column value.
2716 MESSAGE User ! does not have authority to GENPLAN on
table/view !.!.(!) (DBERR 2716)
CAUSE You do not have run authority to GENPLAN on a specified
section.
ACTION Contact your database administrator to get the required
authority or sign on as a user who does have the required
authority.
2717 MESSAGE The specified section !.!(!) is not a SELECT,
UPDATE, DELETE or type II INSERT statement.
(DBERR 2717)
CAUSE The specified section you included is not an allowed
statement for GENPLAN.
ACTION Check the source file to find the right section number.
2718 MESSAGE Optimizer did not generate an access plan for
the query. (DBERR 2718)
CAUSE Internal Error.
ACTION Record as much information as possible and contact your
HP Service Representative or Response Center.
2719 MESSAGE User ! does not have authority to GENPLAN on