Does anyone know how to make an RPG (or indeed Cobol or C - I'm not proud)
stored procedure return more than one result set?

I am familiar with returning *one* result set using a multiple occurrence
data structure (SET RESULT SETS ARRAY ...).

The (limited) documentation appears to suggest that returning two result
sets using MODS is not supported, but that you should be able to return
multiple result sets using SQL cursors, or one MODS result set plus one or
more SQL cursor result sets.

I have totally failed to return even *one* result set using an SQL cursor
(and I would prefer to use the MODS method for all my result sets anyway if
at all possible - it suits my application much better).

Any help very gratefully accepted! I am currently reduced to returning one
result set that combines everything and wastes bandwidth ...


Catalyst Solutions plc.  Registered No 2918101.
Registered @ Kingfisher House, Frimley Business Park, Frimley,
Surrey. GU16 5SG   U.K.

This message is intended only for the named addressee(s) and may
contain confidential and/or privileged information. If you are not the
named addressee you should not disseminate, copy or take any action
or place any reliance on it. If you have received this message in error
please notify and delete the message
and any attachments accompanying it immediately.

| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to
| To subscribe to this list send email to
| To unsubscribe from this list send email to
| Questions should be directed to the list owner:

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by 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.