RE: Accessing AIX Oracle data from IBM i

Thanks for all the suggestions and guidance everyone. You've given me a great deal to think about and research. Now for the fun part, experimenting!

Respectfully,
Kendall Kinnear
System Analyst
Standard Motor Products, Inc.
Mobile: 940-293-7541


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby
Sent: Tuesday, March 20, 2018 3:12 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: 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.

If it was a /remote/ system, you should be safe. :)


On Tue, Mar 20, 2018 at 4:02 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

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
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.dekko.com&d=Dw
ICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKA
WQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=0hMZWAWXInZmFPpH
weH8vn4MJpwQX0ZRicY4G5SrWrQ&e=





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://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_devel
operworks_ibmi_library_i-2Dimproved-2Ddatabase-2D&d=DwICAg&c=CBjl-DmyM
mSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_
eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=QqYh9-AAEmlipsCq6CdTPpKMtJiGEaFw
0HP9XgzDbUA&e=
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://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_devel
operworks_rfe_execute-3F&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ
8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPD
Z__HIGal1E&s=kx0oPZ0d556OavB9DI0Vnl0KI2Zqu5IARyBi0Ke1SgU&e=
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
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.dekko.com&d=Dw
ICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKA
WQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=0hMZWAWXInZmFPpH
weH8vn4MJpwQX0ZRicY4G5SrWrQ&e=





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://urldefense.proofpoint.com/v2/url?u=https-3A__sourceforge.net_p
rojects_appserver4rpg_&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8E
IsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ_
_HIGal1E&s=ffGb7BOjLTZ6XzQl3C-T9AiwqSZ7WQ4hDd6SBDFOYHQ&e=


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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pO
vNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8
VzdLaPDZ__HIGal1E&s=oeYT0pO8gTbcP-s9H6A4aoCElDcCppp4Rw5iczkiDPo&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=ditOZK1Z00cIJ9_LmwxkjNaoMly5Ygrc0DJqWb42SIM&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efs
KAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=BqibLUxiSymnZJ
57LUG2V1ZxFx8gN36JeoTR_LuTrCU&e=


--
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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pO
vNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8
VzdLaPDZ__HIGal1E&s=oeYT0pO8gTbcP-s9H6A4aoCElDcCppp4Rw5iczkiDPo&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=ditOZK1Z00cIJ9_LmwxkjNaoMly5Ygrc0DJqWb42SIM&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efs
KAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=BqibLUxiSymnZJ
57LUG2V1ZxFx8gN36JeoTR_LuTrCU&e=


--
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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pO
vNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8
VzdLaPDZ__HIGal1E&s=oeYT0pO8gTbcP-s9H6A4aoCElDcCppp4Rw5iczkiDPo&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=ditOZK1Z00cIJ9_LmwxkjNaoMly5Ygrc0DJqWb42SIM&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efs
KAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=BqibLUxiSymnZJ
57LUG2V1ZxFx8gN36JeoTR_LuTrCU&e=

--


Jeff Crosby
VP Information Systems
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531
direct.dilgardfoods.com

The opinions expressed are my own and not necessarily the opinion of my company. Unless I say so.
--
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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=oeYT0pO8gTbcP-s9H6A4aoCElDcCppp4Rw5iczkiDPo&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=ditOZK1Z00cIJ9_LmwxkjNaoMly5Ygrc0DJqWb42SIM&e=.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=gMUCqF8_eZvnV0E-66yu3fKQh8VzdLaPDZ__HIGal1E&s=BqibLUxiSymnZJ57LUG2V1ZxFx8gN36JeoTR_LuTrCU&e=
________________________________

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.