SQL Result Sets...again?

["Dane Cox" <DCox@xxxxxxxxxxxxx>]

I'd like to re-visit some posts I've seen (going back a few years)
regarding the return of multiple result sets using RPG.  Apparently it
can be done, but I'm having some difficulty finding any consistent
information.  My main problem revolves around being able to get two (or
more...supposedly up to 20) result sets returned from one stored
procedure.
 
What is the typical tool used for viewing the result set(s) when
returned?  Maybe a better question is how do you typically call stored
procedures that return result sets?   You can call a stored procedure
using RPG (embedded SQL), but you can't get the result set back...how
bizarre is that...or am I missing something?
 
I was able to find the SQL script tool in Ops Nav and it works pretty
well when you have only 'one' array result set.  But, if you have two
array result sets, you simply get back the last one you fill...even if
you've correctly set the number of result sets on your CREATE PROCEDURE
command.  Now, if you change it to a cursor result set, it runs, but you
don't get any results back.  How does one open the cursor and view it
from Ops Nav, or can you?  There is also a way to return an array/cursor
(nested) result set in V5R3, but again, I get nothing back in Ops Nav
when the call completes.
 
Anyway, all this to say that it appears that multiple result sets can be
returned from a stored procedure, but there doesn't appear to be many
ways to actually get to the result sets to view them.  Anybody care to
share their insight on this subject and/or examples of ways to get to
the data?
 
Thanks in advance,
Dane Cox



NOTICE: This electronic mail message and any files transmitted with it are 
intended exclusively for the individual or entity to which it is addressed. The 
message, together with any attachment, may contain confidential and/or 
privileged information. Any unauthorized review, use, printing, saving, 
copying, disclosure or distribution is strictly prohibited. If you have 
received this message in error, please immediately advise the sender by reply 
email and delete all copies.