Re: Accessing another DB with Logging

David Williams <djw@smooth1.demon.co.uk> wrote: :In article <5vnbna$lf4@cssun.mathcs.emory.edu>, gary.vaughan@workcover.n :sw.gov.au writes :> :> :> 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 ?? :> :> Thanks In Advance :> Gary Vaughan :> gary.vaughan@workcover.nsw.gov.au :> :> P.S. Using Informix V7.20 on Dec :> :> : : Create a temp table, unload the data into the temp table, switch : databases and the temp table MAY still be accessible! : : I can't remember if this works under 7.x on not.. I wouldn't bet my application on that. It might possibly work if the temp tables were created in the Unix file system. I would however consider using 4gl to write the data to a file, switch database and read from that file to do the inserts using some of the c utilities available at the iiug site. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org