Re: Iseries to MS-SQL server

[Alan Campin <alan0307d@xxxxxxxxx>]

I use Scott's JDBC api extensively. Best bet in my opinion is to use
Stored Procedures to get or put data. Be happy to send code doing
stored procedure calls and have one example using direct SQL.

On Tue, May 1, 2012 at 2:36 PM, Gary Thompson <gthompson@xxxxxxxxxxx> wrote:
> Yes,
> 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?
>
> Thanks!
>
>
>
> ______________________________________________________________________
> 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 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.