SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-13
SQL 4048
Cause. An INSERT statement included an ANYWHERE clause for a key-sequenced
or entry-sequenced table. The ANYWHERE clause applies only to relative tables; it
indicates where to put inserted rows.
Effect. The statement does not compile.
Recovery. Remove the ANYWHERE clause from the INSERT statement.
SQL 4049
Cause. The DELETE statement tried to delete rows from an entry-sequenced table.
Deleting rows from a table with entry-sequenced organization is not allowed.
Effect. The statement does not compile.
Recovery. If your application requires deletion of rows from the table, you must re-
create the table as a key-sequenced or relative table.
SQL 4050
Cause. An INSERT statement included a placement option, and one of the following
incompatible conditions occurred:
•
The INSERT statement supplied a value for a system-defined primary key column
(SYSKEY by default)
•
The table did not contain a system-defined key column
A placement option describes where to insert the row. An INSERT statement that
supplies a value for the system-defined key column also directs where to put the row. If
the table had no system-defined key column, the placement option does not apply.
Effect. The statement does not compile.
Recovery. Remove the placement option from the INSERT statement.
4048 The ANYWHERE clause is not allowed for this table type.
4049 The DELETE operation cannot be used on an entry-
sequenced table.
4050 The APPEND or ANYWHERE option cannot be specified.