Re: Returning recordsets from stored procedures

Lello, Nick wrote: > > Returning recordsets from stored procedures - Is this even possible in > IDS ? > > > > We have a web application using stored procedures to generate the > report data into temp tables from where we currently select the data; > is it possible in IDS to circumvent the need for the temp tables and > return the data direct from the stored procedure ? > > > > IDS versions in use are 10.0.FC4 and 11.10.FC2 > Absolutely, or to build the temp table anyway for convenience and return the data from the SPL proc itself anyway. Just add the WITH RESUME clause to the RETURN statement inside the FOREACH loop and each time the procedure is called from a cursor in the calling program it will return the next data row. Art S. Kagel Oninit > > > > ------------------------------------------------------------------------ > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > =========================================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ===========================================================================================