Re: Returning result set from external stored procedure

["Wagner, Linda" <Linda.Wagner@xxxxxxxxxxx>]

Birgitta wrote:

> To return a result set from an RPG program, just open the cursor and take
> care that no SQL CLOSE gets executed before progam end. Set Result Set is
> only necessary if you want to return a multi occurence datastructure (or
> array datastructure).


Thanks to Buck, Birgitta and Brian for your suggestions.  Unfortunately,
none of them fixed my problem.  I had already tried just leaving the cursor
open and not using the set result set.  I had also checked the sqlstate
after each statement and it was always normal, however I did modify my
program to use Buck's structure.  The program completed normally however I
still received the message about 0 result sets and the cursor not being
eligible to be accessed as a stored procedure result set.  I also changed my
proc to MODIFIES SQL DATA but that didn't have any effect.

Linda