Re: Dirty Read info

Posted in 1993

Heinrich Seebauer — 10 Nov 1993 06:16:11 GMT — source: Informix-list mailing list archive (1991-1998)

In article <1993Nov8.145344.22870@athen.mch.sni.de> gm@athen.mch.sni.de (Guenther Moschen) writes: > >I'm looking for some background of Informix's "Dirty Read" mode. > >Specifically: How is it invoked? Can it be turned on/off for an entire > >session, or on a per-query basis? > > > >Steven > > > > > > > > It can be turn on with "SET ISOLATION LEVEL TO DIRTY READ" on a per-query > base. It's the default isolation level on a database without logging. > > kind of RT*M question -> Informix 5.0 Reference Manual 5.0 page 7-295 ff. Page 7-294 of the maunal says, that the isolation level is in effect until another SET ISOLATION is issued or the program ends. H. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= /M/A/I Deutschland GmbH Heinrich Seebauer Softwarezentrum Koeln Mathias-Brueggen-Str. 85 Software Engineering 50829 Koeln Federal Republic of Germany Phone: x221/956400-0 Phax: x221/956400-69 email: heinrich@mai.de =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=