Quote:
> >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
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Dirty Read info