Re: Row / Page Locking?

Posted in 2005

Marco Greco — Tue, 22 Feb 2005 12:20:47 +0000 — source: Usenet: comp.databases.informix

Hmmmm, after three or four sql based answers, one cannot but wonder whatever happened to oncheck -pt database:tablename? Claus Samuelsen wrote: > Geezer From The Freezer wrote: > >>Whats the best way to find out if a table is being row or page locked? > > > SELECT locklevel FROM systables WHERE tabname = 'tablename';> > 'R' = row, 'P' = page > > > -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Informix faq http://www.iiug.org/techinfo/faq/informix.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm sending to informix-list