Re: Cursory Stored Procedures?

>From: Steve Proctor <Steve.Proctor@worldnet.att.net> >Date: Tue, 30 Jul 1996 11:07:56 -0500 >X-Informix-List-Id: <news.26677> > >Does anybody know what a Cursory Stored Procedure is? >(Page 1-70, SQL Syntax manual, Version 6.0). All stored procedures which return values can be treated as cursory procedures by declaring a cursor for the EXECUTE PROCEDURE statement. A stored procedure which has a RETURN ... WITH RESUME must be treated as a cursory procedure, and there are limitation on where it can be used in SQL statements (for example, not in the select-list of a SELECT statement). >Does it imply that if a stored procedure selects multiple rows they can >all be returned by the procedure? (that would be good!). Yes -- for example, use something like: FOREACH SELECT ... INTO ... ; RETURN ... WITH RESUME; END FOREACH; >Also, is there an archive on the much underdocumented stored procedure >language? Hopefully containing examples of complex stored procedures. Dunno... Have a look at the FAQ. Poke around http://www.iiug.org. We should start a collection of reusable stored procedures. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>