SQL/MP Messages Manual

SQL Compiler Normalizer Messages (5000 to 5999)
HP NonStop SQL/MP Messages Manual—427720-006
7-2
SQL 5004
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the SELECT statement and recompile.
SQL 5007
Cause. The values to be inserted were selected from the table that is the target of the
insert operation.
Effect. The statement does not compile.
Recovery. Correct the INSERT statement and recompile.
SQL 5008
Cause. You cannot update a shorthand view.
Effect. The statement does not compile.
Recovery. Use a protection view or an underlying table, and recompile.
SQL 5009
Cause. You cannot insert into shorthand views.
Effect. The statement does not compile.
Recovery. Correct the statement and recompile.
5004 The SELECT statement is grouped, either because it has a
GROUP BY clause or because it contains an aggregate function.
A column in the select list that is not a GROUP BY column can
only appear in the argument of an aggregate function.
5007 Values cannot be selected from and inserted into the
same table.
5008 View must be a protection view.
5009 A view column to be inserted into is not a column of an
underlying table.