Re: set isolation
>From: HwaYingLee@pg.SLR.com
>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?
Try
ALTER TABLE ima LOCK MODE(ROW);
HTH.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com