how to connect two databases in sql explorer

[gashah510]

hi to all,

we have two databases . one for production as 'mfgprod' and second for excise as 'mfgexc'. now we want to relate these two databases using sql explorer for query and report purpose since these two r interrelated. But sql explorer allows only single database connection so, how can connect two databases simuntaneously.

can anyone help us in that ?

thanks in advance.

 

[joey.jeremiah]

upgrade to openedge ( r10.1 )

is it something that can be done in 4gl perhaps ?

 

[regulatre]

You might try using javascript by way of a stored procedure? The trick would be making those two connections. Once you did that, the stored procedure would have access to both. It would be worth looking into. The stored procedure could be called relatively simply once you create it.

Or like Joey said, you could use 4gl - OE allows multiple DB connections.

hi to all,

we have two databases . one for production as 'mfgprod' and second for excise as 'mfgexc'. now we want to relate these two databases using sql explorer for query and report purpose since these two r interrelated. But sql explorer allows only single database connection so, how can connect two databases simuntaneously.

can anyone help us in that ?

thanks in advance.