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.

Best Regards,
Jean R.

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

-----Original Message-----
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
with this?


This outbound email has been scanned for all viruses by the MessageLabs
Skyscan service.
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,
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.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].