When working with JDBC or SQLj at runtime

Note:

 JDBC and SQLj are implemented with CLI on DB2, which means the 

db2cli.ini

 settings might affect what is written and run using JDBC and SQLj.

Use the 

setTransactionIsolation

 method in the 

java.sql

 interface connection.

In SQLj, you run the

 db2profc

 SQLJ optimizer to create a package. The options 

that you can specify for this package include its isolation level.

For dynamic SQL within the current session 

Use the

 SET CURRENT ISOLATION

 statement to set the isolation level for dynamic 

SQL issued within a session. Issuing this statement sets the CURRENT 

ISOLATION special register to a value that specifies the level of isolation for any 

dynamic SQL statements issued within the current session. Once set, the 

CURRENT ISOLATION special register provides the isolation level for any 

subsequent dynamic SQL statement compiled within the session, regardless of 

the package issuing the statement. This isolation level will apply until the session 

is ended, or until a SET CURRENT ISOLATION statement is issued with the 

RESET option.

 Chapter 7. Application porting 

233