Re: Accessing another DB with Logging

In article <5vnbna$lf4@cssun.mathcs.emory.edu>, gary.vaughan@workcover.nsw.gov.au wrote: > > > Hi All, > > I have written a 4gl program that reads from one database across a network > > and inserts into another, which has been working fine. Now they want to > change the source database to use logging, but the database that the > program is inserting/updating is not using logging at all. Is there anyway > > around this ?? > Hi Gary, we've solved this problem by splitting the program into 2 pieces. The first program reads the data of database A and generates an unload file. The second program reads the data from the unload file and performs the inserts/updates in database B. It's nor very elegant, but it works... If you get better solutions for this problem, I would be happy if you forward them to me. Dirk Stadtverwaltung Muelheim an der Ruhr Ruhrstr. 32 45468 Muelheim an der Ruhr Tel 0208/455 1006 Fax 0208/455 58 1006 eMail dirk.scheer@stadt-mh.de