Re: set isolation
In comp.databases.informix, "Carlson@WHSmith" <carlson1@bellsouth.net> saw fit to bestow on us:
>Should't be required before each SELECT statement. One per 4gl program
>should be OK. That's how we do it.
Actually, once per transaction (or connect if not xtions are set) should do.
>
>
>John Carlson
>Informix DBA
>WHSmith USA
>
>HwaYingLee@pg.SLR.com wrote:
>>
>> we get error msg frequently
>>
>> Could not position within a table (informix.ima)
>> ISAM error number -107.
>> ISAM error: record is locked.>> when doing select statement(especially lots of user using)
>> and it is solved by adding code "set isolation to dirty read" before every
>> select statement.>>
>> Is there any other way inspite of modifying 4gl program one by one?
>>
>> thanks.
>> hylee
--
Nir Levy nlevy @ usa.net
(((( Groove is in the heart ))))
--
The above opinions are my own, not my employer's.