Re: table locking

On Mon, 7 Dec 1998, Yan Zhu wrote: > How do you lock a table in exclusive mode so no other users can update, > view, or unload the > data until you release the lock. LOCK TABLE TableName IN EXCLUSIVE MODE; Beware transaction boundaries. Note that a process does the locking; if the process dies, the table is unlocked. Also note that only the locking process can access the table after successfully executing that statement -- child processes are locked out just as much as unrelated processes are. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn