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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-223
SET TRANSACTION Statement
SET TRANSACTION Statement
Considerations for SET TRANSACTION
MXCI Examples of SET TRANSACTION
C Examples of SET TRANSACTION
COBOL Examples of SET TRANSACTION
The SET TRANSACTION statement is used to set attributes for the next transaction
(and only the next transaction). The attributes are the isolation level, access mode,
size of the diagnostics area, and whether to automatically commit changes made to the
database. The isolation level and the access mode affect the degree of concurrency
available for transactions.
transaction mode
is an option that can be set in a SET TRANSACTION statement. You cannot
specify any of the options—isolation level, access mode, size of the diagnostics
area, or autocommit—more than once within one SET TRANSACTION statement.
You cannot use the AUTOCOMMIT option in combination with any other option.
isolation-level
specifies the level of data consistency defined for the transaction and the
degree of concurrency the transaction has with other transactions that use the
SET TRANSACTION transaction-mode [,transaction-mode]...
transaction-mode is:
isolation-level
| access-mode
| diagnostics-size
| autocommit-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
diagnostics-size is:
DIAGNOSTICS SIZE number-of-conditions
autocommit-option is:
AUTOCOMMIT {ON | OFF}
C/COBOL
C/COBOL