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

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual—523730-004
6-38
SQL 4164
Cause. You attempted to perform a right join using an embedded expression as the
outer relation.
Effect. SQL/MX is unable to compile the statement.
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. 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. 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. SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
4164 Outer relation of right join cannot be embedded name
expression. Tables in scope: name.
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.