Re: LOCK TABLE in exclusive mode

Posted in 1998

Rainer Schaub — Thu, 16 Jul 1998 16:41:54 +0200 — source: Informix-list mailing list archive (1991-1998)

until you say "commit work" which free the table lock (or unlock table when you do not use Transactions) the table is locked at a whole. this needs one lock. this statement doesn't change the locklevel at your table which is by default PAGE. you can see it whith the folloing sql-staement: select tabname, locklevel from systables where tabname = "TABLE"; rainer BlackStar wrote: > When I lock a table in exclusive mode using the LOCK TABLE statement > on a table with row locking as default, does INFORMIX automatically > promote the locking of this table to TABLE/PAGE LEVEL locking? > > Thanx > > Standard Disclaimer