SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-62
Statement Atomicity
Statement Atomicity
These attributes affect NonStop SQL/MX’s ability to undo the effects of an insert,
update, or delete operation, when an error occurs during the operation, without having
to abort the entire transaction:
Statement Recompilation
These attributes affect statement recompilation at execution time:
Attribute Setting
UPD_ABORT_ON_ERROR Controls whether an error that occurs during the
performance of an insert, update, or delete causes an
abort.
ON means that NonStop SQL/MX will abort a user
transaction after an error in an IUD statement. This
behavior is similar to that of SQL/MX Release 1.8.
OFF means that NonStop SQL/MX will not abort a user
transaction after an error in an IUD statement.
The default is OFF.
UPD_SAVEPOINT_ON_ERROR Controls whether DP2 savepoints are to be used and
whether the transaction is aborted in case of an error
during an IUD statement.
ON means that DP2 savepoints are used, if possible.
OFF means that DP2 savepoints are not used and that
the transaction will be aborted in case of an error.
The default is ON.
Attribute Setting
AUTOMATIC_
RECOMPILATION
Set to ON or OFF. If set to ON, an SQL statement is
automatically recompiled at run time, depending on the
outcome of various factors. If OFF, NonStop SQL/MX
does not recompile the statement and returns an error if
various comparisons fail.
The default is ON.
INTERACTIVE_ACCESS Set to ON or OFF. If set to ON, the compiler selects the
most appropriate index-based access plan. If OFF, the
compiler follows normal behavior and does not
emphasize index-based access plans.
The default is OFF.