IIRC, that didn't work with ARDGATE for some reason. Maybe Dieter will come along give us a definitive answer. I can't test it, because ARDGATE on my system got ran over by the train wreck that was my 7.3 update. It had been in the testing stage when we did the update, so when I couldn't get it running properly after reasonable effort, I just gave up on it.
-----Original Message-----
From: Rob Berendt [mailto:rob@xxxxxxxxx]
Sent: Tuesday, March 20, 2018 1:32 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Accessing AIX Oracle data from IBM i
<snip>
but at 7.1 you had to do a SQL CONNECT to connect to the remote DB, and then a CONNECT RESET to target Db2 again. That would prevent mixing DB's like your example.
</snip>
7.1 had three part naming which allowed my examples. IDK if it was day one or as part of some DB2 Group PTF.
Wait! Found it!
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/RDB%20alias%20support%20for%203-part%20SQL%20statements
RDB alias support for 3-part SQL statements
Want to know when?
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM+i+Technology+Updates/page/DB2+for+i+Functional+Enhancements
Love it when some say "three part naming" and others say "3-part"...
But I can remember the days of what you are talking about.
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 02:12 PM
Subject: RE: Accessing AIX Oracle data from IBM i
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
No, not sure about the activation groups. I was sure when I typed it, but
now I'm having doubts.
I haven't used ARDGATE since 7.1, but at 7.1 you had to do a SQL CONNECT
to connect to the remote DB, and then a CONNECT RESET to target Db2 again.
That would prevent mixing DB's like your example.
-----Original Message-----
From: Rob Berendt [mailto:rob@xxxxxxxxx]
Sent: Tuesday, March 20, 2018 12:36 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Accessing AIX Oracle data from IBM i
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
midrange.com
