Re: SQL Result Sets...again?

As I recall (it was before yesterday), one of the Java applications (at 
another company) accessed the multiple result sets I returned from the 
stored procedure I wrote.  I think they had to process (or close) the 
first result set to get access to the second one.

Differences between returning cursors and arrays (if they exist) have 
certainly left me by now.

Hope this helps.

Wayne

L. Wayne James
Senior Developer
Agilysys, Inc.
Hospitality Solutions Group
578 Old Norcross Road
Lawrenceville, GA 30045
Phone:  770-962-6425 x1252
Email:  Wayne.James@xxxxxxxxxxxx



"Dane Cox" <DCox@xxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
06/15/2004 12:06 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
<rpg400-l@xxxxxxxxxxxx>
cc

Subject
SQL Result Sets...again?






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.



--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.