Re: lock mode

ajay@ios.ho.att.com (-A.DANKAR) wrote: > >What is the default lock mode (page/ row) in informix tables >(using on-line, if it matters) and also, is there any utility >(dbschema etc.) one can use to see the current lock mode of a >table? > >-- > ____________________________________________________ > | Ajay Dankar AT&T Bell Laboratories | > | ajay@ios.ho.att.com Holmdel, NJ 07733 | > |____________________________________________________| 1) Page is the default lock level if lock mode is not specified. 2) To see the current lock mode of a table, run this query from dbaccess: Select locklevel from systables where tabname = table_name;