SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual—523730-004
6-35
Recovery. Modify the WHERE clause to use the primary key of the table expression.
SQL 4151
Cause. You attempted to access a nonupdateable view using stream access mode.
Effect. SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4152
Cause. You attempted to read from and update the same table.
Effect. SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4153
Cause. You attempted to compile a stream expression using an ORDER BY on
columns that do not define the prefix of the clustering key of the base table or of a
secondary index.
Effect. SQL/MX is unable to compile the statement.
Recovery. Create a secondary index whose clustering key materializes the order and
resubmit.
SQL 4154
Cause. You attempted to compile an embedded DELETE or embedded UPDATE
expression using an ORDER BY without using a clustering key or a secondary index.
Effect. SQL/MX is unable to compile the statement.
Recovery. Create a secondary index materializing the order and resubmit.
4151 Stream access is supported only on updatable views.
View: table name.
4152 Table name cannot be both read and updated.
4153 Statement may not compile due to an order requirement on
stream expression.
4154 Statement may not compile due to an order requirement on
embedded name expression.