Neoview Messages Manual (R2.2)

SQL 4150
4150 Primary key of table expression name must be used for join with
embedded operation expression. Tables in scope: name.
Cause You performed an embedded DELETE or UPDATE and are now attempting to join
the result set of whatever that operation was with the result set of another expression. You
did not use the primary key of the second expression for your join. You must use the primary
key to prevent returning multiple rows being returned for a single deleted or updated row.
Effect The HP Neoview database software is unable to compile the statement.
Recovery Modify the WHERE clause to use the primary key of the table expression.
SQL 4151
4151 Stream access is supported only on updatable views. View: table
name.
Cause You attempted to access a nonupdatable view using stream access mode.
Effect The HP Neoview database software is unable to compile the statement.
Recovery Modify the statement and resubmit.
SQL 4152
4152 Table name cannot be both read and updated.
Cause You attempted to read from and update the same table.
Effect The HP Neoview database software is unable to compile the statement.
Recovery Modify the statement and resubmit.
SQL 4153
4153 Statement may not compile due to an order requirement on stream
expression.
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 The HP Neoview database software is unable to compile the statement.
Recovery Create a secondary index whose clustering key materializes the order and resubmit.
SQL 4154
4154 Statement may not compile due to an order requirement on embedded
name expression.
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 The HP Neoview database software is unable to compile the statement.
Recovery Create a secondary index materializing the order and resubmit.
SQL 4156
4156 Inner relation of left join cannot be embedded command name. Tables
in scope: name.
Cause You attempted to perform a left join using the result set of an embedded UPDATE
or DELETE as the inner relation.
Effect The operation fails.
Recovery Modify the statement and resubmit.
147