<verndor response>
If you are open to a commercial offering, you might want to look at our RPG2SQL Integrator product. It is a set of procedures that let you operate in real time with remote databases, including SQL server.

It has 3 procedures for calling SQL stored procedures, as well as all the other stuff you might want for SQL. It also has extensive Excel functionality that gives you the full scope of Excel's capability if you want.

I've also written an Open Access: RPG Edition handler that lets you do regular IO to the remote database with traditional RPG opcodes - requires you to be on at least 6.1 of the OS.

Check it out at or call us at 888.RJS.SOFT - you can ask for me or for Richard (we would be development mostly) or for sales.
</verndor response>


On 5/10/2011 10:37 AM, Mike Wills wrote:
> From RPG or from STRSQL? You can from RPG, you need to use iSeries
Access or RDP otherwise. (From the guy that asked this a few months

Mike Wills

On Tue, May 10, 2011 at 10:25 AM, Billy Waters
<bwaters@xxxxxxxxxxxxxxxxxx> wrote:
Is it possible to call a SQL Server stored Procedure from AS400?

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

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 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].