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

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.