Re: How to check if a table is locked

Posted in 1996

Billy Wheeler — 18 May 1996 17:28:28 -0400 — source: Informix-list mailing list archive (1991-1998)

At 08:07 AM 5/18/96 GMT, Abdu wrote: >: I am working with SQL in a informix SE engine. I don't know how to check >: if a table is locked and the lock mode of the database. > >I don't know the answer. How about reading a value, updating and >comparing? LOCK MODE is something you can find in the system catalogs. (I think - no manuals to hand :) If you want to see if something is locked, try lock a record. If you get error -246, the record is locked. You could try lock the entire for the same results... HTH. Hasta la vista! -- billy.wheeler@pixie.co.za