SQL/MX 3.1 Messages Manual (H06.23+, J06.12+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Release 3.1 Messages Manual—663849-001
6-37
SQL 4157
Cause. You attempted to perform a left join using the result set of a stream expression
as the inner relation.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4158
Cause. You attempted to perform a join of stream expressions.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4159
Cause. You attempted to perform an intersection of stream expressions.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4160
Cause. You attempted to perform an intersection between two embedded
expressions.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
4157 Inner relation of left join cannot be stream expression.
Tables in scope: name.
4158 Join of stream expressions is not supported. Tables in
scope: name.
4159 Intersection of stream expressions is not supported.
Tables in scope: name.
4160 Intersection between embedded name1 expression and
embedded name2 expression is not supported. Tables in scope:
name3, name4.