Mail bounced...
Quote:
Steven Bonisteel 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,
The command you want is:
set isolation to dirty read
committed read
cursor stability
repeatable read
"After a set isolation statment executes, the new isolation level
remains in effect until you enter another set isolation statement or
until the end of the program."
See Informix Guide to SQL Reference pp. 7-294 through 7-296 for more
info.
- Cathy
--------------------------------------------------------------------------------
Veterinary Teaching Hospital Phone: (303) 491-1294
Colorado State University Fax: (303) 491-1205
--------------------------------------------------------------------------------
Disclaimer:These are my opinions and may not represent anything at all relevant.