Re: Accessing AIX Oracle data from IBM i

[Charles Wilt <charles.wilt@xxxxxxxxx>]

You can load an Oracle JDBC driver to the i and use that... either via Java
or via an an DRDA<-->JDBC Gateway...

The DRDA<-->JDBC gateway allows for the use of embedded SQL in RPG.

Dieter Bender (who's on these list) has an opensource project, ARDGATE part
of APPSERVER4RPG...
https://sourceforge.net/projects/appserver4rpg/


Oracle also offers a product, "Transparent Gateway", that will make the
Oracle DB look like a DRDA DB2 DB from the i and will make the i DB look
like an Orcale DB from the Oracle box.  Expect to pay some big $$$.

Charles




On Tue, Mar 20, 2018 at 9:14 AM, Kendall Kinnear <
Kendall.Kinnear@xxxxxxxxxxx> wrote:

> Okay, to start with let me say I know nothing about AIX and Oracle. So
> having said that, this morning I was asked how we can use an RPG program on
> IBM i to access data on an AIX Oracle database.
>
> A little background, we are in the process of removing the AIX systems at
> one of our locations and as an interim step the programmers want to be able
> to read and update files on the AIX system.
>
> I found a listing for an old Oracle product call Access Manager for AS/400
> (cringe!). I'm hoping there's another method like ODBC, JDBC, or NFS that
> can be used.
>
> Any thoughts would be appreciated.
>
> Respectfully,
> Kendall Kinnear
> System Analyst
> Standard Motor Products, Inc.
> Mobile: 940-293-7541
>
> ________________________________
> Please consider the environment before printing this email.
>
> The content of this e-mail (including any attached files) is confidential
> and may be privileged and protected by law. It is intended solely for the
> purpose of the person to whom it is addressed. If you are not the intended
> recipient of this message, please notify the sender immediately and delete
> the message (inclusive of any attached files). In addition, if you are not
> the intended recipient of this message, any disclosure, copying,
> distribution or taking any action in reliance of the contents of this email
> is strictly prohibited.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> 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: http://amzn.to/2dEadiD