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

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual523730-004
6-36
SQL 4156
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
Cause. You attempted to perform a left join using the result set of a stream expression
as the inner relation.
Effect. 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. 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. SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
4156 Inner relation of left join cannot be embedded command
name. Tables in scope: name.
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.