Re: How to use fetch while calling sql stored procedure in rpg ?

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

A bit more on using CLI in RPG - did a google on 
"sql cli rpg" - turns out Craig Pelkie has done a 
lot of work on this. He has a presentation at 
http://www.web400.com/Penton/rpg_cli.pdf and the 
various resources needed at http://www.web400.com/Penton/rpgcli.html

At 07:06 AM 3/2/2006, you wrote:

> If what you mean is "read from a Result Set that is being returned by
> the stored procedure" ...
> ... AFAIK that's not possible unless you use CLI.
> Would be glad to hear from somebody else the oposite!
> Antonio
>
> Luqman escribió:
>
> >How can I retrieve results from Stored Procedure while using it in RPG ?
> >
> >say :- I called a sql stored procedure MYPROC in my SQLRPGLE Program.
> >
> >
> >C/EXEC SQL
> >C+ CALL MYPROC(:H1,:H2)
> >C/END-EXEC
> >
> >Now how can I display this result, as in case of cursor, we use" fetch
> >cursor name into variable name"
> >
> >Best Regards,
> >
> >Luqman
> >
> >
> >
> >
> >
> >
> >
>
> --
> Antonio Fernandez-Vicenti
> afvaiv@xxxxxxxxxxxxxx
>
>
>
> --
> 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.