SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-14
SQL 4051
Cause. An INSERT operation was attempted on a protection view whose definition
referred to the system-defined primary key column and whose underlying table had
relative organization. Because of the view definition, the INSERT statement must
supply a value for the system-defined key column, and the INSERT statement must not
include a placement option (APPEND or ANYWHERE).
Effect. The statement does not compile.
Recovery. Supply a value for the system-defined key column in the INSERT
statement, and remove any placement options.
SQL 4052
Cause. The UPDATE statement requested an update of at least one column of the
primary key. Updating a primary key is not allowed.
Effect. The statement does not compile.
Recovery. Delete the row, and then insert a new row with the new value for the
primary key.
SQL 4053
Cause. A query expression contained SELECT * for a view that had no user-defined
columns; the view contained only a system-defined primary key column. Because
SELECT * returns only user-defined columns, the query expression could not contain
any select list items.
Effect. The statement does not compile.
Recovery. Specify SYSKEY explicitly in the select list.
4051 A value for the system-defined primary key column
(SYSKEY by default) must be provided.
4052 Column value-1 is a primary key column and cannot be
updated.
4053 The select list is empty.