× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Dan, I agree, Dieter Bender deserves much credit.

I have installed and used ArdGate and it works well.

You are correct about ADDRDBDIRE.

I especially like that it also supports ad hoc query
of remote db from STRSQL.

If I can help anyone with ArdGate, just ask (Dieter is the expert).



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Kimmel
Sent: Tuesday, December 06, 2011 8:12 AM
To: Midrange Systems Technical Discussion
Subject: RE: For Christmas, I want

I actually got the ear of IBM on this very issue a couple of years ago through a COMMON requirement submission through the CAAC (Common Americas Advisory Committee). The answer I got was, "we don't have enough resources to commit to such a project with limited interest". However, they did point me to the documentation to build one myself. My call for developers to an open source project for this resulted in very limited response.

DB2 has long supported an "open" standard for interconnectivity called DRDA. If another database box supports DRDA, you can add it to your relational database directory (ADDRDBDIRE). However, DB2 is the only database that supports DRDA. You can hook your i box to a mainframe running DB2 or to DB2 running on AIX on Intel or Power, but you can't hook it up to MySQL or SQL Server.

It would be tedious, but not difficult, to build a DRDA connector for MySQL, for example, and put that in the open source community.

Deiter Bender did some interesting work on this. I think he hooked up a DRDA connector to Java so you could configure up a JDBC connection pool and hook it up to i jobs with ADDRDBDIRE. I haven't tried his code, but the descriptions make it look like it should work. Maybe someone on the list has tried it?


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Tuesday, December 06, 2011 8:19 AM
To: Midrange Systems Technical Discussion
Subject: For Christmas, I want

For Christmas, I want the IBM Rochester system i team to do something significant to make the i a true server of choice.
I think I remember that 'server of choice' phrase from times past, but the gap I continue to see is the difficulty of querying foreign SQL DB from DB2 on i.

Some years ago, from MS Sql Server or Access I could "easily"
create 'pass-through' queries against DB2. But the reverse required a purchase.

Now, I am working through that same dilemma and wonder why
DB2 on i does not have native ability to exchange data with other ANSI compliant Db.

Out of the box, so to speak.

--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.



--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.