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-40
SQL 4173
Cause. You attempted to perform a top-level UPDATE statement that included a
stream expression.
Effect. SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4174
Cause. The SQL/MX compiler could not reorder the join tree because the
JOIN_ORDER_BY_USER directive is in effect.
Effect. SQL/MX is unable to compile the statement.
Recovery. Disable the JOIN_ORDER_BY_USER directive and resubmit.
SQL 4175
Cause. You attempted to perform a join between two embedded expressions.
Effect. SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4176
Cause. You attempted to perform a join between a stream expression and an
embedded expression.
Effect. SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
4173 Stream expression is not supported for top level UPDATE
statements.
4174 JOIN_ORDER_BY_USER prevented compiler from reordering
query tree.
4175 Join between embedded name1 expression and embedded
name2 expression is not supported. Tables in scope: name3.
4176 Join between stream expression and embedded name1
expression is not supported. Tables in scope: name2.