Oninit cdi / Archive
Talk to an expert →

Informix Transactions

Posted in 1995

John C. Sinues — — source: Informix-list mailing list archive (1991-1998)

In Informix, when you begin a transaction with BEGIN WORK, why can't I select records from one of the tables in the transaction while the transaction is in progress? Does Informix, by default, lock the table in EXCLUSIVE MODE, when a transaction begins? Do I have to explicitly "LOCK TABLE table_name IN SHARE MODE" for others to read a row from the table while the transaction is in progress? ============================================================================ _/_/_/_/ _/_/_/_/ _/_/_/_/ John C. Sinues _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ Inc. _/_/_/_/ _/_/_/_/ _/ eMail: sinues@prc.prc.mrms.navy.mil _/ _/ _/ _/ Phone: (804) 498-5666 _/ _/ _/ _/_/_/_/ Fax: (804) 498-5670 ======================================= | "...life is robust and meant to be | lived, joyfully...but not perfectly- | except by accident." ============================================================================