isolation level RR
Posted in 1997
"Katarina Hamzova" — — source: Informix-list mailing list archive (1991-1998)
PLEASE HELP ME
My question :
How does isolation level repeatable read work
I thought it places share locks on every row
selected in queries in transaction -
i did this:
begin work;
set isolation to repeatable read
select * from table where ......
i expected it places locks
on rows according to where clause.
But it placed share lock on table .
Am i missing something ?
Informix On line 7.20 DSA - SNI
Informix On line 7.22 WGS - Win NT
databases created in non Ansi mode
unbuffered logging
thanks
katarina
--
Katarina Hamzova Voice : +42 7 5384324
SWH s.r.o Bratislava
Slovakia
Internet : Katarina.Hamzova@swh.sk