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

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

That is right - the Redbook (SG24-6503) Stored 
Procedures, Triggers, and User Defined Functions, 
says, on page 136, that you must use CLI, JDBC, 
or ODBC to get result sets from stored 
procedures. (I believe you can get array-style result sets, however.)

But there is no reason not to use the CLI stuff 
in RPG. There is a copy book called SQLCLI in 
QSYSINC/QRPGLESRC, but it has only some DS's for date, time, & timestamp.

The prototypes for all the CLI stuff is in C/C++ 
format in QSYSINC/H, member SQLCLI. You'd need to 
convert a lot of that - a useful exercise if 
someone has not done so already. Then you can use 
it all in RPG. Of course, you don't need to make 
a copy book for it all, just use the right data types.

Good luck
Vern

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.