SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
6-38
SQL 4160
Cause. You attempted to perform an intersection between two embedded
expressions.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
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.
4160 Intersection between embedded name1 expression and
embedded name2 expression is not supported. Tables in scope:
name3, name4.
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.