Neoview SQL Reference Manual (R2.3)

SET TRANSACTION Statement
• “Syntax Description of SET TRANSACTION”
• “Considerations for SET TRANSACTION”
• “Example 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 COMMITED
| SERIALIZABLE
| REPEATABLE READ
access-mode is:
READ ONLY | READ WRITE
diagnostics-size is:
DIAGNOSTICS SIZE number-of-conditions
autocommit-option is:
AUTOCOMMIT {ON | OFF}
norollback-option is:
NO ROLLBACK {ON | OFF}
autoabort-interval is:
AUTOABORT [ timeout | 0 | RESET]
timeout is:
integer {HOURS[S] | MINUTE[S] | SECOND[S]}
autobegin-option is:
AUTOBEGIN {ON | OFF}
multicommit-option is:
MULTI COMMIT [ON]
| MULTI COMMIT OFF
170 SQL Statements