|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
