I second that, we used Scott Klement's service program JDBCR4 using jTDS
JDBC Driver (open source Type 4/Pure Java driver).
Works like charm, The only thing you want to ensure is to do the loading
test, depends on how much load of data you need to interface.
From: Gary Thompson <gthompson@xxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 05/01/2012 01:37 PM
Subject: RE: Iseries to MS-SQL server
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Scott Klement's service program JDBCR4
ArdGate - available on sourceforge.net
ProData's RDB Connect product
all allow read, write, update from system I to various remote db
From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Tuesday, May 01, 2012 2:30 PM
To: Midrange Systems Technical Discussion
Subject: Iseries to MS-SQL server
Is it possible to retrieve or update an SQL server database directly from
the iseries via RPG or COBOL?
Not file transfer but record retrieval & updates.
Is anyone familiar with any utilities or products or APIs that would help
This outbound email has been scanned for all viruses by the MessageLabs
For more information please visit http://www.symanteccloud.com
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l