SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-64
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
DOOM_USERTRANSACTION Controls whether NonStop SQL/MX dooms a transaction
when it encounters an unrecoverable error and the
transaction cannot be rolled back to a savepoint. When a
transaction is doomed by TMF, it is marked for abort and
has to be aborted explicitly. A new transaction is started
before the user can proceed.
When set to ON and NonStop SQL/MX cannot roll back
to a savepoint, it dooms the transaction.
When set to OFF, NonStop SQL/MX dooms the
transaction if it inherits the transaction from the user
application or the JDBC or ODBC drivers. NonStop
SQL/MX aborts the transaction if it started the
transaction.
The default is OFF.
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.