Dirty Read info 
Author Message
 Dirty Read info

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



Mon, 22 Apr 1996 22:49:18 GMT
 Dirty Read info

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.

guenther

--
*----------------------------------------------------------------------------*

* UNIX Consultant      | PHONE   : 089/63642171                              *
*       c/o            |   A consultant is a person who borrows your watch,  *



Fri, 26 Apr 1996 22:53:44 GMT
 Dirty Read info

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

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=



Sun, 28 Apr 1996 14:16:11 GMT
 
 [ 3 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