Re: Cursory Stored Procedures?

Posted in 1996

Richard Thomas — 31 Jul 1996 05:28:30 -0400 — source: Informix-list mailing list archive (1991-1998)

Steve Proctor wrote: > > Does anybody know what a Cursory Stored Procedure is? > > (Page 1-70, SQL Syntax manual, Version 6.0). > > Does it imply that if a stored procedure selects multiple rows they can > all be returned by the procedure? (that would be good!). > > Also, is there an archive on the much underdocumented stored procedure > language? Hopefully containing examples of complex stored procedures. Hi Steve, On page 2-21 of the same book, it says "a procedure that returns more than one row or set of values is called a cursory procedure". This is in the section on "foreach", a command which is the SP equivalent of a cursor. HTH, Richard.