Updating sysdefaults

Posted in 2000

Jeff Larsen — Wed, 23 Aug 2000 16:38:22 GMT — source: Informix-list mailing list archive (1991-1998)

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