Re: Accessing the AS/400 from Oracle

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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