DB2 isolation level with JDBC

you can either change the isolation property at the connection method, and this isolation will hold for every statement you execute, or you can change the isolation level at the statement level by adding with XX at the end of the statement, for example

select * FROM mytable with CS
select * from mytable with UR

I was told that I can also change the db2cli.ini file
Is this true ?
What do I have to put there ?
Do you have a sample ?

I forgot to mention : the application can access DB2 or Oracle or mySQL (depends on our customer needs) so better to have the isolation level specified "outside" the code of the application

Hi LeTay,

Depending on the client that you're using to access DB2, you can also change the default isolation level.

  SET ISOLATION LEVEL UR/CS/etc.


Kent

We use JDBC
I think that I have to modify db2cli.ini