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

SET SESSION

The SET SESSION statement is a CA IDMS SQL extension used to set options and default transaction attributes for the SQL session. JDBC applications can set the following SQL session options:

• SET SESSION CHECK SYNTAX SQL89|FIPS|EXTENDED
• SET SESSION CURRENT SCHEMA schema-name|NULL
• SET SESSION SQL CACHING ON|OFF|DEFAULT

CA IDMS treats these options as user session options when they are executed in an XAConnection and applies them to the SQL session for the local transaction as well as the SQL sessions for any global transactions. It also propagates the options to any subordinate sessions used by procedures and table procedures.

JDBC applications should not set the following options directly:

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

JDBC applications should use the Connection setReadOnly and setTransactionIsolation methods to set transaction options instead so that the driver can maintain transaction attributes internally.

According to the JDBC specification, the behavior of these methods is implementation defined when the connection is associated with a global transaction. In this case, the CA IDMS JDBC driver applies the transaction options only to the current transaction branch.