Re: Stored procedures and multiple record set returns

What about the following SPL code snippet: .. foreach select col1, col2, ..., colN into var1, var2, ..., varN from myTable return var1, var2, ..., varN with resume; end foreach; .. It works for me in 9.13. Cheers, Jozsef Arun Shastry wrote: > I'm working with some stored procedures and noticed something really > cool > that Sybase/MS SQL Server have and Informix doesn't. > > In either one of the other DBMS's, if the last statement is a SELECT > that > returns multiple records, that would be returned to the calling > application > too. Informix returns a nasty -659 SQL error. I guess I could get them > > into a set of local variables and loop thru them, but the other approach > > would have been great. > > Arun