Re: Locking Mode

At 10:49 PM 6/1/95 GMT, -A.GARG wrote: }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 ? It is contained in systables, tb/oncheck output, and dbschema with -ss option (6.x and greater). }I could change the locking mode by ALTER TABLE XXX LOCK MODE (ROW/PAGE)... } }And also could you guys tell me, what is the default locking mode in }Informix ? The default is page level locking. } }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 }--------------------------------------------------------------------------- } } } } ================================================================== Jon Vemo Internet: jvemo@cyberspace.com Bothell, WA USA ------------------------------------------------------------------ Watch out for road-kill on the information superhighway....SPLAT!! ==================================================================