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-47
SQL 4210
Cause. You attempted to embed UPDATE/DELETE statements within an IF
statement.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4212
Cause. You specified table name, a partitioned table, as the order requirement on a
stream.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4213
Cause. You attempted to use a rowset as a predicate with an embedded update or
embedded delete.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4214
Cause. You attempted to use a SET ON ROLLBACK clause to update a column in a
nonaudited table.
Effect. The operation fails.
Recovery. Change the table’s AUDIT attribute and resubmit.
4210 Embedded update/delete statements not supported within
an IF statement.
4212 table name cannot be used to satisfy order requirement
on the stream because it is partitioned.
4213 Use of rowsets in a predicate with embedded
update/delete is not supported.
4214 The SET ON ROLLBACK clause is not allowed on a non-
audited table. Table: name.