<verndor response>
Our RPG2SQL product can do this very nicely - easy procedures to call to do the work.

It also works directly with Excel workbooks - not using SQL or Java.

If interested, feel free to call me or Richard at 888.rjs.soft (toll-free) or email me or ask for sales.

I even have an Open Access handler for it. This actually gives you access to remote databases with minimal changes to your RPG code - very cool, if I may say so myself!
</verndor response>

On 12/6/2011 8:49 AM, Chris Bipes wrote:
Me Too
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Tuesday, December 06, 2011 6: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.


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.