RE: For Christmas, I want

Not quite the same thing, but you can also use PHP on the i to access MS SQL Server. I use it for two daily jobs. One reads and updates about 1800 entries and runs for 5 seconds total. In an interactive, exiting job, it's about 2 seconds typically (depending on server load.)
--
Sean Porterfield


-----Original Message-----
From: Gary Thompson

Paul, thank you.

For the most recent project I installed and ran comparisons of read/write/update between DB2 and MS Sql server and remote DB2 using:

1) Scott Klemment's JDBCR4 service program and
example code from Scott and Jon Juracich

2) ArdGate open source application with help
from Dieter Bender (many thanks)
a good solution that also enables remote DB
access from STRSQL

3) ProData RDB Connect (ProData also sells and supports DBU)

We also received a bid from an IBM business partner for
a "Federated Server" solution $$$
original thought was we only needed DB2 Connect

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Nelson
Sent: Tuesday, December 06, 2011 7:40 AM
To: 'Midrange Systems Technical Discussion'
Subject: 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: 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 email is confidential, intended only for the named recipient(s) above and may contain information that is privileged. If you have received this message in error or are not the named recipient(s), please notify the sender immediately and delete this email message from your computer as any and all unauthorized distribution or use of this message is strictly prohibited. Thank you.