Re: accessing two database one with logging and without

Posted in 1997

Nils Myklebust — Tue, 18 Mar 1997 01:51:07 GMT — source: Informix-list mailing list archive (1991-1998)

rcyrus@promarkone.com wrote: :We have databases on Version 5.03 and version 7.22 online. The 5.03 :online instances have NO logging ON (previous DBA!!!). The 7.22 instances :have Logging ON. : :DBACCESS and ISQL and the 4GL code does not allow the access of Non :logging and a logging database at the same time. : :Anybody out there with any workarounds? (we can't turn on logging for the :5.x instances!!) We would really appreciate any ideas!! : :robin cyrus :ProMark One :Scottsdale AZ The only thing you can do in 4GL is to use the database statement to connect to one database. Select something into local variable. Then database again to connect to the other and use the data there. Probably not fast. In dbaccess/ISQL you can only unload to file from one and load from file to the other. 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