Re: Set transaction isolation level read uncommitted?

Mark D Stock wrote: > > 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. > I recommend the following SET TRANSACTION LEVEL TO READ UNCOMMITTED. An advantage of this ANSI-Compliant statement is that if there is an unfinished transaction, the above statement will generate an SQL/ISAM code error. Chao