The SET TRANSACTION management statement overrides the default characteristics of a transaction. The default characteristics are established during access module compilation or, for transactions initiated by the Command Facility, by CA IDMS, and may subsequently have been overridden by a SET SESSION statement.
You can issue only one SET TRANSACTION statement in any given transaction.
None required.
►►─── SET TRANSACTION ────────────────────────────────────────────────────────► ►─┬──────────────┬───────────────────────────────────────────────────────────► ├─ READ ONLY ─┤ └─ READ WRITE ─┘ ►─┬────────────────────┬─────────────────────────────────────────────────────►◄ ├─ CURSOR STABILITY ─┤ └─ TRANSIENT READ ───┘
For the duration of the transaction in which the statement is executed, SET TRANSACTION parameters override the defaults. A SET TRANSACTION statement must specify at least one parameter; the combination of READ WRITE and TRANSIENT READ is invalid.
Order of Execution
If used, the SET TRANSACTION statement must be executed before any statement in the transaction other than:
Default Transaction Characteristics
Default transaction characteristics are initially established during access module compilation. If not specified as parameters on a CREATE or ALTER ACCESS MODULE statement, and for transactions initiated through the Command Facility, the default transaction characteristics are:
These initial defaults can be changed by issuing a SET SESSION statement.
Setting Isolation Level
The following SET TRANSACTION statement specifies that the transaction has an isolation level of transient read:
EXEC SQL
SET TRANSACTION
TRANSIENT READ
END-EXEC
|
Copyright © 2014 CA.
All rights reserved.
|
|