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-47
SQL 4208
Cause. You attempted to use an index for stream access that does not cover all base
table columns referenced in the WHERE clause.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Add the missing columns to the index.
SQL 4209
Cause. You attempted to perform a rollback that included an update of a nullable
column.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
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.
4208 Index name and other indexes covering a subset of
columns do not cover all columns referenced in WHERE clause
of stream.
4209 Update of nullable column name is not permitted on
rollback.
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.