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.