Re: Viewing existing lock mode

Posted in 1996

Bill Ennis — 25 Jul 1996 10:23:34 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, This information is held in the systables table in the database. systables is created by informix. Specifically: select locklevel from systables where tabname ="table-you-want-here"; -Bill > > We are trying to find out if a table in the database has row, table or > page locking. We are running with on-line version 5.02. Is there > anyway we can look this up on the current database? Thanks for your > help in advance. > > Wendy > walm@icsware.com > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com