RE: For Christmas, I want

Luis, thank you for your informative and 'seasonal' response.

Also, please note my reply to Paul

Finally; yes, there are many gifts received on these forums
and lists: thank you all . . .

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Tuesday, December 06, 2011 7:43 AM
To: Midrange Systems Technical Discussion
Subject: Re: For Christmas, I want

Gary,

Not quite "out of the box" standard, I suppose, but using JDBC and some routines, Scott Klement has provided the community with a simple method to access non-IBM i DBs.

We have been using Scott's routines for some time now against an Oracle DB without any problems. It is maybe not as fast as we would like (probably more an issue with our OS/Java release than anything else), but it is quite adequate.

Also, Dieter Bender has some routines that allows you to do a "CONNECT TO" to foreign DBs, using STRSQL, for instance.

So maybe the gift has already been received, and you just missed the sender's name :-)

Best Regards,

Luis

On 12/6/11, Gary Thompson <gthompson@xxxxxxxxxxx> wrote:

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.

--
Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries
--
--
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.