Re: Using dbload to update rather than insert?

Posted in 1994

Colin Mcgrath — 16 Sep 1994 11:03:09 -0400 — source: Informix-list mailing list archive (1991-1998)

Brian Holman writes: > > ... I have > two separate files ... The two files may contain > duplicates and I only allow for unique ID numbers in the table. Is there a > way with dbload to have it UPDATE rather than INSERT. If you know which file should take precedence, load that file first, then use dbload on the second file with the -e flag set to some large #, greater than the number of duplicate records you expect. If one file has newer data for certain fields, and the other file has newer data for other fields, you will have to load them into separate tables and use SQL or 4GL to update the one with the data from the other. -- Colin McGrath Internet: colin@scdipc0.ueci.com Raytheon Engineers & Constructors Inc. UUCP: ..!uunet!trac2000!trac3000!cmm 30 S. 17th St Voice: 215-422-3449 Philadelphia, PA, 19101 FAX: 215-422-4095 <Standard disclaimers apply>