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-44
SQL 4196
Cause. The HAVING predicate refers to a renamed column in the select list.
Effect. The statement does not compile.
Recovery. Correct the column name in the HAVING predicate.
SQL 4198
Cause. You specified the clustering key columns in the SET clause of an embedded
UPDATE statement.
Effect. The statement does not compile.
Recovery. Remove the clustering key columns from the SET clause and recompile
the statement.
SQL 4199
Cause. You specified the SET ON ROLLBACK clause while updating the clustering
key columns.
Effect. The statement does not compile.
Recovery. Remove the SET ON ROLLBACK clause and recompile the statement.
SQL 4200
Cause. You attempted to use a stream expression for a compound statement.
Effect. The statement does not compile.
Recovery. Modify the statement and resubmit.
4196 The HAVING clause that uses a renamed column cannot
contain an aggregate or a subquery.
4198 Clustering key columns cannot be specified in the SET
clause of an embedded UPDATE statement.
4199 SET ON ROLLBACK clause cannot be specified when
clustering key columns are specified in the SET clause of an
UPDATE statement.
4200 Stream expressions are not supported for compound
statements.