Re: Multiple DB access
Posted in 1997
On Tue, 4 Nov 1997, Claude E. Desrochers wrote: > I am looking for a way, if at all possible, using a single 4gl program, > to read a table from one Informix database and write to another Informix > table sitting in a different db. > > Environment: Informix SE 7.1.0 > Informix 4GL 6.02 > Platform AIX 4.1.2 Well, with OnLine you could do it more easily than with SE, but you can do it by digging in the IIUG archives (http://www.iiug.org) for the I4GL connection management code, and then using two separate connections, one to each database. You'd have to switch connections back and forth when you needed to switch from reading to writing. Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>