Re: Accessing the AS/400 from Oracle

Oracle calls it a "database gateway"

Try starting here
https://www.oracle.com/technetwork/database/gateways/index.html

IIRC, they have a generic gateway using ODBC (JDBC?)

They also have a "transparent gateway for IBM DB@ and DRDA" which not only
makes your IBM i look like an Oracle DB to Oracle, but allows your IBM i to
see the Oracle DB as just another Db2 Server.

Very nice, but very pricey.

Charles


On Thu, Sep 12, 2019 at 6:08 AM Alan Shore via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi everyone
Before I forget - we are on V7r3

We have been asked to give access to some of the DB2 tables on the AS/400
from our Oracle system using DBLINK

I googled
AS400 DBLINK
But did not find any one site that shows what needs to be done on the
AS/400 side for this to happen

Can anyone point me in the right direction?


Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com