Re: Set transaction isolation level read uncommitted?

Dallan Quass wrote: > > I have a particular situation where I _want_ a transaction to > see the effect of uncommitted writes (please don't tell me that > I shouldn't be doing this -- it's in a very controlled environment). > > Is it possible in Informix to set the transaction isolation level > of a read-only transaction to read uncommitted, so that the > transaction sees the uncommitted writes of other ongoing transactions? > > (In Oracle I have found that it is not possible.) Er... I think you mean: SET ISOLATION TO DIRTY READ If I understand you correctly. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |Email: marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+