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.
midrange.com
