Help with commited read (Was Re: I'm looking for FAQ!)

In article <43ek85$i8n@sun1000.ci.pwr.wroc.pl>, biprogeo@sun1000.ci.pwr.wroc.pl (BIPROGEO) wrote: > Help me!! > I'm starting 4GL programming and I have several problems with > My problem is: > I have LOCK MODE COMMITED READ. > User X1 doing UPDATE without COMMIT. > User X2 can't do any SELECT on this table. > Why? How can I solve this problem.??? When you say "COMMITED READ" you're telling the engine that you're not going to let anybody read any data unless it has been commited to the database. While the UPDATE is going on there is an implicit transaction going on (regardless of the fact you have no BEGIN and COMMIT) and so the engine is stopping X2 from looking at the data X1 is changing, until X1's UPDATE is complete. ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.2 Mar 95 Quanta Systems, Auckland | kcbbs.gen.nz:/informix/informix.[faq|apx] New Zealand. Work: +64 9 377-4473 | mathcs.emory.edu:/pub/informix/faq/ " " Home: +64 9 279-3571 | http://www.garpac.com/informix.html