Transaction problem

Posted in 1995

Clem Akins — 5 Apr 1995 17:48:04 -0400 — source: Informix-list mailing list archive (1991-1998)

From: sinues@prc.prc.mrms.navy.mil (John C. Sinues) Subject: Transaction problem > I'm having trouble reading rows after I begin a transaction. > > I have a program that updates a number of tables. I uses a BEGIN WORK > statement to begin a transaction. While my program is running, I > am not able to select all the rows from any of the tables that I change > (using an INSERT or UPDATE) within my transaction. The tables were > created with the ROW LOCK instead of the default PAGE LOCK mode. I am > not doing any LOCK TABLE commands. Is there anything that I need to > add to my program to enable others to read from the tables that I > am changing? [...sig deleted...] Sure. Set your isolation level to "dirty read". OTOH, this comes with a price. See the discussion under "Concurrency and Locking" in the Informix Guide to SQL Tutorial, pg 7-24. "Sailors do it wetter, Soldiers do it *better*!" -David Allen Coe __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|