Re: HELP Informix Locks

David Williams wrote: > > > This is a feature, when you update/delete a row in a table it takes an > EXCLUSIVE mode on the row/page depending upon on the lock mode of the > table. This means no-one else can READ or write to the table. > > Locking the table in SHARE mode means that no-one else can write to > the table but they can READ from the table. > > When updating you need to take out an exclusive lock so that no-on can > read the old version or a partly updated version. When you take a > share lock out on a table you stop other people from writing to it > whilst you are reading it. > -- > David Williams David, then the "Guide to SQL" Reference Manual (Sep. 1992) erroneously states on Page 7-195: "If you issue a LOCK TABLE statement before you access a row in the table, no row locks are set for the table." ^^^^^^^^^^^^ As I have an old version of this manual I don't know if it is corrected in newer versions. Regards Tolis +---------------------------------------------------------------------+ | V+K Relational Solutions email: tvarnas@compulink.gr | | Deligiorgi 26 tvarnas@orbit.de | | 546 42 Thessaloniki Voice: (30) 31 820270 | | Greece Fax: (30) 31 865463 | +---------------------------------------------------------------------+