Re: accessing two database one with logging and without

Nils.Myklebust@idg.no (Nils Myklebust) writes: > 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. Are you limited to the tools you list? If not, there are probably several solutions available. DBD::Informix (a perl interface to Informix) can do it. Nils will probably tell you about a UDBC solution. -- 'yvind Gjerstad Systems dept Tollpost-Globe AS N-6301 'ndalsnes/Norway E-mail: ogj@it.tollpost.no Phone: +47 7122 6663 Fax: +47 7122 6694