SET TRANSACTION question
Hi all
Anyone used SET TRANSACTION (or SET ISOLATION LEVEL) to change the
isolation level of a transaction? The docs state that '... after
a COMMIT WORK statement completes the transaction or a ROLLBACK WORK
statement cancels the transaction, the isolation level is reset to
the default.'
This doesn't seem to be happening.
For example ...
- my default isolation is committed read
- from dbaccess I run:
begin work;
set transaction isolation level repeatable read;
select count(*) from tbl_name; commit work;
- onstat -g sql shows iso lvl as RR (repeatable read), so the commit
has *not* reset to the default.
Anyone seen this behaviour before. Are the docs wrong, or is this
a 7.12 bug.
TIA
Peter Whittleton (whittle@ssax.com)