Re: SQL Stored Procedure

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Billy

<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 
http://www.rjssoftware.com/Products/Catalog/RPG2SQL-Integrator/ 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>

Vern

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
> ago).
>
> --
> Mike Wills
> http://mikewills.me
>
>
>
> 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?
> >
> > Thanks..
> > --
> > 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.