Re: Informix 4gl query

Posted in 2003

Fernando Nunes — Tue, 14 Oct 2003 12:25:06 +0100 — source: Usenet: comp.databases.informix

Suket wrote: > Hi, > > I have an Informix 4gl programs will following 2 lines : > SET ISOLATION TO DIRTY READ > SET LOCK MODE TO WAIT> > Can anybody throw light how database access in multiple user scenario > will take place with above setting. Can "phantom" record problem > occur? Yes. ISOLATION LEVEL is different from LOCK MODE. Even in DIRTY READ there are some statements wich may encounter LOCKS. DML statements for example. Regards.