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-41
SQL 4174
Cause. The SQL/MX compiler could not reorder the join tree because the
JOIN_ORDER_BY_USER directive is in effect.
Effect. NonStop 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. NonStop 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. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4177
Cause. You attempted to update clustering key components or columns associated
with referential integrity constraints during a rollback.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
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.
4177 Update of name1 column name2 is not permitted on
rollback.