Dirty Read Info 
Author Message
 Dirty Read Info

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.



Tue, 23 Apr 1996 07:38:11 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Dirty Read info

2. Row locked on reads even under dirty read

3. SQL Server: dirty-reads possible?

4. Dirty reads

5. MSSQL 6.5 + triggers + "dirty reads"

6. dirty read from linkserver table

7. Allow dirty read

8. What exactly is a dirty read?

9. dirty read from linked sever table

10. dirty read

11. Allowing Dirty Read

12. strange lock acquired during a SELECT (using dirty read)


 
Powered by phpBB® Forum Software