RE: Calling stored procedure from RPG

[Mike Cunningham <mike.cunningham@xxxxxxx>]

Did IBM ever add the ability for embedded RPG to read a result set that was returned from another RPG program that was defined as an external procedure? Without using the CLI interface.  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Sunday, November 06, 2011 3:01 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Calling stored procedure from RPG

On 06-Nov-2011 11:16 , Albert York wrote:
> I need to call a stored procedure that has two input parameters and 
> four output parameters.
>
> Can anyone give me an example of how that would be coded in RPG?

   In a SQLRPGLE source, something like the following might be coded:

       Exec SQL
           call myStoredProc  (:i1, :i2, :o1, :o2, :o3, :o4) ;

Regards, Chuck
--
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.