Re: LockLevel question

Posted in 1999

Vardan Aroustamian — Tue, 20 Jul 1999 16:15:36 -0500 — source: Informix-list mailing list archive (1991-1998)

Bobby Medus wrote: > > Hello all, > > I am trying to find a way to determine a tables locklevel from the > Sysmaster database. I see that "sysdic" has a "dic_locklevel" that is > set to 1 for page and 2 for row but this is only benifitial if the table > is being accessed at the time of query. I know I can get it in the > systables in each database but security restrictions forbid me from > doing this on certain databases. > It's probably sysptnhdr.flags. Check 'insert into flags_text ...' statements in sysmaster.sql > Any help is appreciated as always. > > Bobby HTH Vardan -- vaar@geocities.com