How to control isolation levels in Toad Data Point for DB2 connections?
SOLUTION 1:
Use the Toad Options: If you set it in options window, all new subsequent connections you define will use that Isolation level value:
SOLUTION 2:
You can specify the Isolation level per connection – via the advanced tab in the connection properties.
SOLUTION 3:
Within a SQL Editor window, type the SET commands and query the Isolation level.
