Re: Updating a Remote Database?

Salvatore Saieva (saieva@dpg.rnb.com) wrote: : My need is to update a remote database each day. I would like to export : the data from my local database to ASCII flat files using the SQL unload : statement and then make it available for downloading (using Zmodem, : Kermit, or some other modem protocol) by the remote site. : At the opposite end a script will run which will use a SQL load statement : to load the data into the remote database. My problem is that some of the : records that are exported from my local database will update existing records : in the remote database. The SQL load command only allows an insert clause : for records being loaded from a flat file. I do this all the time using a "duplicate table" that is normally empty. I run a dbload into this table then insert/update as needed from there to the "real" table, deleteing from the "duplicate" as I go. : I'm running Online 5.04 on Solaris 2.4. Any (and all) other suggestions : greatly appreciated. : Sal. : --- : Salvatore Saieva : PRINCIPIA Partners, LLC E-Mail: uunet!merccap!saieva : Harborside Financial Center Phone: (201) 946-0300 : 902 Plaza II, 9th Floor Fax: (201) 946-0320 : Jersey City, NJ 07311 : Exhortation: ``Aesthetics are more important than efficiency.'' -DEK -- /"""\\ Kelvin Burton, Mercy Ships, Lindale, TX 75771-2020 |O.O| burtonk@MercyShips.ORG; uunet.uu.net!cairns!burtonk \\_=_/