SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-10
SQL 4039
Cause. An attempt was made to INSERT, DELETE, or UPDATE a shorthand view. A
view must be a protection view to permit these operations.
Effect. The statement does not compile.
Recovery. If the query expression defining the view is valid for a protection view, re-
create the view as a protection view and use the protection view. Updating a shorthand
view is not allowed.
SQL 4040
Cause. The specified object did not exist. If this message was issued as a warning at
compile time, the program containing this statement is valid, but the object must exist
before running the program.
Effect. The statement does not compile.
Recovery. Check the program name for correctness. Check that the program exists
before executing this statement.
SQL 4041
Cause. The name specified in the FROM clause of the query expression that defined
the protection view was a view, not an underlying table. The table specified in a
protection view definition must be an underlying table.
Effect. The statement fails.
Recovery. If the underlying view is a shorthand view, create a shorthand view, which
can be defined on underlying views and tables. If the underlying view is a protection
view, define an equivalent protection view by defining it on the underlying table and
merging the WHERE clause of the protection view with the new WHERE clause.
4039 This operation cannot be performed on a shorthand view.
4040 Program value-1 cannot be found.
4041 A protection view definition cannot contain a view.