× 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 don't know if Dieter's ARDGATE works using DRDA but, yes, you manage
your "foreign" DB with WRKRDBDIRE and acces it using a "CONNECT TO"
SQL statement. And it works very nicely...

Regards,

Luis Rodriguez


On 12/6/11, Dan Kimmel <dkimmel@xxxxxxxxxxxxxxx> wrote:
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.