Re: Updating sysdefaults

I think that the manual is right on this one.... ;-) It's not so important what is in the disk, but what is in memory in the dictionary cache. By changing what is on disk, you are bypassing the coordination with the dictionary cache, and --- well.... Jeff Larsen wrote: > Our salesmen are always changing their minds about default > values for new customer records. We have a 24-7 system and > I have to kick everybody out just to be able to execute... > > alter table customer modify rate char(1) default 'V';> > I know the manual says DON'T DO IT, but just how much trouble > could I get in by executing... > > update sysdefaults set default = 'V' where tabid = 252 and colno = 23;> > Thanks, > > Jeff -- Madison Pruet =========================================== Enterprise Replication Product Developement Dallas, Texas Informix Software ===========================================