×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
This mailing list archive is Copyright 1997-2024 by midrange.com 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.
midrange.com
