Re: Is there a DBIMPORT like util to append to an existing DB?

Posted in 1994

Richard Spitz — Fri, 18 Mar 1994 17:40:22 GMT — source: Informix-list mailing list archive (1991-1998)

Rajesh Malhotra (manmetha@gauss.rutgers.edu) wrote: : [...]When I import it, I want the records to be appended : to the existing tables, not overwrite them. I cannot use DBIMPORT, since : it recreates the database. You could use the DBLOAD utility. See your Informix manuals for details. It might get a little cumbersome to do it all over again for 30 tables, but it works, provided that you have no unique key in your tables (which you definitely SHOULD have in a relational database!). Alternatively, you could use the "LOAD FROM ..." SQL command. Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+