SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-4
SQL 4018
Cause. You specified a protection view or defined a cursor used for update that
contains a join.
Effect. The statement does not compile.
Recovery. Remove the join.
SQL 4019
Cause. You specified a CREATE VIEW or DECLARE CURSOR with the FOR
UPDATE clause, but the defining query expression contained multiple tables in the
FROM clause. A query expression with multiple tables cannot be updated; therefore,
you cannot use the expression to define a view or a cursor that can be updated.
Effect. The statement does not compile.
Recovery. If you do not want to update the cursor, remove the FOR UPDATE clause.
SQL 4020
Cause. You specified a CREATE PROTECTION VIEW or DECLARE CURSOR
statement with the FOR UPDATE clause, but the defining query expression contained
a HAVING clause. A query expression with a HAVING clause cannot be updated;
therefore, you cannot use the expression to define a protection view or a cursor that
cannot be updated.
Effect. The statement does not compile.
Recovery. If you do not want to update the view, declare a shorthand view instead. If
you do not want to update the cursor, remove the FOR UPDATE clause. Then, reissue
the statement.
4018 A protection view or cursor definition used for update
cannot contain a join.
4019 The DISTINCT keyword cannot be specified in a CREATE
VIEW statement or in a DECLARE CURSOR statement with the FOR
UPDATE clause.
4020 A protection view or cursor definition used for update
cannot contain a HAVING clause.