RPG/Cobol/C stored procedures / result sets

[mandy.shaw@xxxxxxxxxxxxxxxxxxxxxxxxx]

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 ...

Thanks
Mandy

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

NOTICE:
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 postmaster@catalyst-solutions.com and delete the message
and any attachments accompanying it immediately.
----------------------------------------------------------------------


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---