Re: dummy update

Posted in 2005

Art S. Kagel — Thu, 17 Nov 2005 15:50:55 -0500 — source: Usenet: comp.databases.informix

tomcaml@yahoo.com wrote: > hello! > > anyone have a script or trick to spit put dummy updates needed for all > tables in all DB's? > > as in, update carriertbl set add_user = add_user where 1=1; Get my package utils4_ak. It contains several AWK/NAWK/GAWK scripts that read dbschema or myschema DDl and output various sets of statements to operate on a whole DB's worth of tables. It should not be hard to use one as a template for what you want to do. Art S. Kagel