We offer a product called RPG to SQL Integrator that can read/write SQL Server as well as other databases and Excel Spreadsheets directly.
You no doubt have already talked to Bill Whalen since CHS is an RJS customer :-)
Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
------------------------------
message: 2
date: Tue, 1 May 2012 20:29:54 +0000
from: "Stone, Joel" <Joel.Stone@xxxxxxxxxx>
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!