SQL/MX 3.x Messages Manual (H06.22+, J06.11+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual—640324-001
6-39
Recovery. Modify the statement and resubmit.
SQL 4165
Cause. You attempted to perform a right join using a stream expression as the outer
relation.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4166
Cause. You attempted to use an ORDER BY clause in the UNION of two streams.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4167
Cause. You attempted to perform a subquery that included an embedded statement.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4168
Cause. You attempted to perform a subquery that included a stream expression.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
4165 Outer relation of right join cannot be stream
expression. Tables in scope: name.
4166 ORDER BY clause is not supported in UNION of two
streams. Tables in scope: name1, name2.
4167 Embedded name statements are not supported in
subqueries.
4168 Stream expressions are not supported in subqueries.