Neoview SQL Reference Manual (R2.4 SP2)

SET TRANSACTION Statement
• “Syntax Description of SET TRANSACTION”
• “Considerations for SET TRANSACTION”
• “Examples of SET TRANSACTION”
The SET TRANSACTION statement sets attributes for transactions. It stays in effect until the
end of the session or until the next SET TRANSACTION statement, whichever comes first.
Therefore, the SET TRANSACTION statement can set the attributes of all subsequent transactions
in the session. SET TRANSACTION statements are not cumulative; each SET TRANSACTION
statement erases all the settings specified by previous SET TRANSACTION statements. If you
want to set multiple transactions attributes, they must all be specified in a single SET
TRANSACTION statement. To reset all transaction attributes to their default values, simply use
a SET TRANSACTION attribute to set a single attribute to its default value.
SET TRANSACTION transaction-mode [,transaction-mode]...
transaction-mode is:
isolation-level
| access-mode
| diagnostics-size
| autocommit-option
| norollback-option
| autoabort-interval
| autobegin-option
| multicommit-option
isolation-level is:
ISOLATION LEVEL access-option
access-option is:
READ UNCOMMITTED
| READ COMMITTED
| SERIALIZABLE
| REPEATABLE READ
access-mode is:
READ ONLY | READ WRITE
autocommit-option is:
AUTOCOMMIT [ON] | AUTOCOMMIT OFF
norollback-option is:
NO ROLLBACK [ON] | NO ROLLBACK OFF
autoabort-interval is:
AUTOABORT [ timeout | 0 | RESET]
timeout is:
integer {HOURS[S] | MINUTE[S] | SECOND[S]}
autobegin-option is:
AUTOBEGIN [ON] | AUTOBEGIN OFF
multicommit-option is:
MULTI COMMIT [ON] | MULTI COMMIT OFF
Syntax Description of SET TRANSACTION
transaction mode
specifies the attributes that you can set. You cannot specify any of the options more than
once within one SET TRANSACTION statement. You cannot use the AUTOCOMMIT or
AUTOBEGIN options with any other option.
SET TRANSACTION Statement 187