Re: How to check if a table is locked

Lock mode is in the systables "locklevel" is the column name ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Sat, 18 May 1996, Billy Wheeler wrote: } 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 } }