Re: accessing two database one with logging and without
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.
>
> In dbaccess/ISQL you can only unload to file from one and load from
> file to the other.
My solution for clients has been to have them break into C language from
their 4GL code, spawn a child process to access the non-logged database
and use some IPC (Message queue? Shared memory?) to get at that data.
This way you can keep the communication lines open on both databases.
--
-- Jake (Lost in thought and won't ask for directions)
. .
_..-'( )`-.._
./'. '||\\\\. }\\_/{ .//||` .`\\.
./'.|'.'||||\\\\|.. )o o( ..|//||||`.`|.`\\.
./'..|'.|| |||||\\`````` \\,@,/ ''''''/||||| ||.`|..`\\.
./'.||'.|||| ||||||||||||. ||| .|||||||||||| ||||.`||.`\\.
/'|||'.|||||| ||||||||||||{ | }|||||||||||| ||||||.`|||`\\
'.|||'.||||||| ||||||||||||{ | }|||||||||||| |||||||.`|||.`
'.||| ||||||||| |/' ``\\||`` | ''||/'' `\\| ||||||||| |||.`
|/' \\./' `\\./ \\!|\\ /|!/ \\./' `\\./ `\\|
V V V }' `\\ /' `{ V V V
\\ \\ \\ V / / /
+-----------------------------------------------------------+
| Impeccable Logic: A thought process which successfully |
| resists chicken bites |
+-----------------------------------------------------------+