Re: Locking Mode

In article <D9InDw.2vL@nntpa.cb.att.com>, anurag@ios.ho.att.com says... > >Hi Informix experts, > >Is there any way to find out the current locking mode of a table.. >I mean is it row level/page level locking ? >I could change the locking mode by ALTER TABLE XXX LOCK MODE (ROW/PAGE)... > "dbschema -d dbname -t tablename -ss" will show the lock mode. >And also could you guys tell me, what is the default locking mode in >Informix ? > Page level lock is default mode. >Thanks in advance... > >anurag > >--------------------------------------------------------------------------- >Anurag Garg Telephone : >2D-220, AT&T Bell Labs +1-908-949-4789 (W) >101, Crawfords Corner Rd, +1-908-583-5667 (R) >Holmdel NJ#07733 USA anurag@ios.ho.att.com >--------------------------------------------------------------------------- > >