JDBC Programmer Reference › Distributed Transactions › Using SQL Transaction and Session Commands › SET TRANSACTION

SET TRANSACTION

The SET TRANSACTION statement is a CA IDMS SQL extension used to set the current transaction attributes:

• SET TRANSACTION CURSOR STABILITY|TRANSIENT READ
• SET TRANSACTION READ ONLY|READ WRITE

The transaction attributes are reset to the default, which can be specified by the SET SESSION statement. JDBC applications should use the Connection setReadOnly and setTransaction Isolations methods instead of executing these commands.