Any utility to auto-transfer table from one DB to another DB

Posted in 2000

JouhShenToh@pg.SLR.com — Tue, 10 Oct 2000 11:39:18 +0800 — source: Informix-list mailing list archive (1991-1998)

Hi, I have a set of scripts to do drop-create-load-index a collection of tables from one database to another database. However, all target table schema has an extra field, sysflag char(1), as the first field. Is there any utility can automate this process? Any help would be greatly appreciated. Thanks. Regards, Jouhshen

↪ replying to JouhShenToh@pg.SLR.com

Art S. Kagel — Mon, 16 Oct 2000 15:51:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Use dbload to do the reload portion. The .cmd file would look like: {BEGIN atable.cmd} FILE "atable.unl" delimiter "|" 7; insert into atable values ("1", f01, f02, f03,.....,f07);{END atable.cmd} Art S. Kagel JouhShenToh@pg.SLR.com wrote: > > Hi, > > I have a set of scripts to do drop-create-load-index a collection of tables > from one database to another database. However, all target table schema has > an extra field, sysflag char(1), as the first field. > > Is there any utility can automate this process? Any help would be greatly > appreciated. Thanks. > > Regards, > Jouhshen