RE: For Christmas, I want

Gary,

There are tools out there that permit you to grab "off-platform" data. The
price tags are not that bad, compared to the cost of rolling your own.

Paul Nelson
Office 512-392-2577
Cell 708-670-6978
nelsonp@xxxxxxxxxxxxx


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