Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual—640324-001
6-45
SQL 4203
Performing INSERT, UPDATE, or DELETE operations on a nonaudited table could
corrupt the index if the operation is interrupted. Use the
IUD_NONAUDITED_INDEX_MAINT attribute value to control if these operations
create an error condition, are allowed with a warning, or are allowed with no warning.
This message appears as a warning or as an error, depending on how you have set
this attribute value.
Cause. You attempted to perform an INSERT, UPDATE, or DELETE operation on a
nonaudited table and IUD_NONAUDITED_INDEX_MAINT is set to OFF. This message
is displayed as an error.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
Cause. You attempted to perform an INSERT, UPDATE, or DELETE operation on a
nonaudited table and IUD_NONAUDITED_INDEX_MAINT is set to WARN. This
message appears as an warning.
Effect. NonStop SQL/MX performs the INSERT, UPDATE, or DELETE operation. If
the operation encounters an error, you will see other messages about that condition.
Recovery. Informational message only; no corrective action is needed.
SQL 4204
Cause. You attempted to use stream access on a table that is not key-sequenced,
which is required.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Modify the statement and resubmit.
SQL 4205
Cause. You attempted to perform an embedded action that is supported only for
key-sequenced tables.
Effect. NonStop SQL/MX is unable to compile the statement.
4203 Insert/Update/Delete operation on non-audited table name
requires index maintenance which may cause the index(es) to
become corrupt.
4204 Stream access is supported for only key-sequenced
tables. Table: name.
4205 Embedded name1 is supported for only key-sequenced
tables. Table: name2.
To Next Page