RE: Accessing AIX Oracle data from IBM i -- MIDRANGE-L

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