Neoview Messages Manual (Volume 1) (R2.4)

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.
SQL 4157
4157 Inner relation of left join cannot be stream expression. Tables
in scope: name.
Cause You attempted to perform a left join using the result set of a stream expression as the
inner relation.
Effect The HP Neoview database software is unable to compile the statement.
Recovery Modify the statement and resubmit.
SQL 4158
4158 Join of stream expressions is not supported. Tables in scope: name.
Cause You attempted to perform a join of stream expressions.
Effect The HP Neoview database software is unable to compile the statement.
Recovery Modify the statement and resubmit.
SQL 4159
4159 Intersection of stream expressions is not supported. Tables in
scope: name.
Cause You attempted to perform an intersection of stream expressions.
Effect The HP Neoview database software is unable to compile the statement.
Recovery Modify the statement and resubmit.
SQL 4160
4160 Intersection between embedded name1 expression and embedded name2
expression is not supported. Tables in scope: name3, name4.
Cause You attempted to perform an intersection between two embedded expressions.
Effect The HP Neoview database software is unable to compile the statement.
Recovery Modify the statement and resubmit.
SQL 4161
4161 Embedded INSERT, UPDATE or DELETE statement is not allowed in a
UNION operation. Tables in scope: table-names1, table-names2.
150 Binder and Compilation Messages (4000 Through 4999)