Re: Viewing existing lock mode

Joel Schumacher wrote: <snip> > I'm not certain, but I would recommend using the "ALTER TABLE" statement > to change these, rather than updating the table directly. > > Can anybody confirm whether there's a difference? Does something other > than this column get changed? ie. a physical change to the tables? > There is a significant difference. If you just update systables that will have no effect on the locking level of the table. That infomation is stored in the partition page of the table and alter table will update that to reflect the change in lock level while just an update to systables will not change the partition page. Jacques -- ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * ********************************************************************