Re: Accessing AIX Oracle data from IBM i

I just had to flee from a group of villagers with pitchforks and torches
because it left a lock on that file.

Be really careful to do stuff like
with nc
when doing selection from a remote system when doing stuff like
create table rob.deletemex as (
select * from gdihq.erplxf.rco)
with data

I just had to flee from a group of villagers with pitchforks and torches
because it left a lock on that file.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Rob Berendt <rob@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 03/20/2018 01:36 PM
Subject: RE: Accessing AIX Oracle data from IBM i
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Are you sure about that? Are you saying that I can't do this:
STRSQL
create table rob.deletemex as (
select * from gdihq.erplxf.rco)
with data
Table DELETEMEX created in ROB.
insert into rob.deletemex (
select * from gdihq.erplxf.rco)
8 rows inserted in DELETEMEX in ROB.

gdihq is a remote IBM i database

<snip>
Remote three-part naming is nothing new and has been around since IBM i
7.1.
</snip>
https://www.ibm.com/developerworks/ibmi/library/i-improved-database-
interoperability-sql-rdb/i-improved-database-interoperability-sql-rdb-pdf.
pdf


I was given to believe that Deiter's product allows other databases to be
part of this. I believe he does it by filling in this parameter
Application requester driver: ARDPGM
in the ADDRDBDIRE command. Hence the name: ARDGATE. You can roll your
own if you want to.

It gets a little irritated with some operations such as
select lcl.cmpny, lcl.cmpnam, rmt.cmpnam
from erplxf.rco lcl, gdihq.erplxf.rco rmt
where lcl.cmpny = rmt.cmpny
Statement references objects in multiple databases. (SQL0512)

select lcl.cmpny, lcl.cmpnam, rmt.cmpnam
from erplxf.rco lcl left outer join gdihq.erplxf.rco rmt
on lcl.cmpny = rmt.cmpny
Statement references objects in multiple databases.

Tried to get this fixed but IBM told me to get off.
https://www.ibm.com/developerworks/rfe/execute?
use_case=viewRfe&CR_ID=94447



Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 03/20/2018 11:57 AM
Subject: RE: Accessing AIX Oracle data from IBM i
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



ARDGATE works well if you don't need to operate on both local Db2 and the
remote DB at the same time. (You can't connect concurrently to different
DB's from the same activation group).



-----Original Message-----
From: Charles Wilt [mailto:charles.wilt@xxxxxxxxx]
Sent: Tuesday, March 20, 2018 10:28 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Accessing AIX Oracle data from IBM i

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

--
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


--
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


--
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