Re: table locking

hmm, tried that, the user is still able to perform select statement on it and unload the data to a text file. yan Jonathan Leffler wrote: > 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