SET TRANSACTION

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.
idmscu19
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.
Authorization
None required.
Syntax
  ►►─── SET TRANSACTION ────────────────────────────────────────────────────────►  ►─┬──────────────┬───────────────────────────────────────────────────────────►    ├─ READ ONLY  ─┤    └─ READ WRITE ─┘  ►─┬────────────────────┬─────────────────────────────────────────────────────►◄    ├─ CURSOR STABILITY ─┤    └─ TRANSIENT READ ───┘  
Parameters
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.
Usage
Order of Execution
If used, the SET TRANSACTION statement must be executed before any statement in the transaction
other than
:
  • CONNECT
  • SET ACCESS MODULE
  • SET SESSION
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:
  • READ WRITE
  • CURSOR STABILITY
These initial defaults can be changed by issuing a SET SESSION statement.
Example
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
More Information