Re: accessing two database one with logging and without
At 05:25 AM 3/18/97 GMT, Nils Myklebust wrote:
}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.
Actually, don't you have to write the 'connect' functionality in esql/c (or
some such), since I do not believe current releases for 4GL support the
'connect' syntax.
}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
}
----------------------------------------------------------------------------
---
Jon C. Vemo "Life is like a dogsled team, if you ain't the
jvemo@cyberspace.com lead dog the scenery never changes."
----------------------------------------------------------------------------
---