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-38
SQL 4161
Where table-names1 and table-names2 are names of NonStop SQL/MX tables
that are in scope.
Cause. You attempted to perform a UNION operation that has embedded an INSERT,
UPDATE, or DELETE statement.
Effect. The operation failed.
Recovery. Modify the statement and resubmit.
SQL 4162
Cause. You attempted to perform a GROUP BY in conjunction with a stream
expression.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4163
Cause. You attempted to perform a GROUP BY in conjunction with an embedded
expression.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4164
Cause. You attempted to perform a right join using an embedded expression as the
outer relation.
Effect. NonStop SQL/MX is unable to compile the statement.
4161 Embedded INSERT, UPDATE, or DELETE statement is not
allowed in a UNION operation. Tables in scope: table-names1,
table-names2.
4162 GROUP BY is not supported for stream expression. Tables
in scope: name.
4163 GROUP BY is not supported for embedded name1 expression.
Tables in scope: name2.
4164 Outer relation of right join cannot be embedded name
expression. Tables in scope: name.