Re: direct read/write to MS SQL from RPG

Jon, the product you're referring to is RPG2SQL Integrator which can be used for reading and writing real-time data and Excel files from any RPG application.

Very easy to implement with a bindable service program to achieve sub-second data access to SQL Server data and store procedures.

You can view a couple of recent webinars I did and download a demo from the HelpSystems site.
https://www.helpsystems.com/products/data-integration-software-windows-and-ibm-i

Regards,

Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com

----------------------------------------------------------------------

message: 1
date: Fri, 27 Jan 2017 20:03:10 -0500
from: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
subject: Re: direct read/write to MS SQL from RPG

As Alan has said it can indeed be done. JCBC is not the only option though if your boss is willing to spend a few $s.

Our colleague Vern Hamburg worked on a project now owned by Help Systems which provides the ability to either code at an API level, or by using an Open Access handler to allow a SQL Server table to be read/written by regular RPG opcodes. That would make your task pretty easy I would think. I've looked at Help's web site but I'm darned if I can work out what the product is now called so hopefully Vern will chime in.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com