Re: Locks/Committed Read Problem

wyang wrote: > > Mark Oberfield wrote: > } > } > lock on that row. This will lead to a deadlock and Informix will = > } > timeout. > > I don't think this will lead to a deadlock. Because there is only on lock, > committed read doesn't try to lock anything. If you have set lock wait ... statement, some lock messages will become deadlock messages. If you don't set lock wait, there will not be deadlock messages. Chao