>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>