Stored procedures and multiple record set returns

Posted in 1998

Arun Shastry — Mon, 08 Jun 1998 14:10:29 -0400 — source: Informix-list mailing list archive (1991-1998)

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

Related threads

Simple question - can't find answer
LOTOFILE and Stored Procedures
Re: Informix Positive Post #2
Table length
Re: Simple question - can't find answer