how do you get rows out of a SP ???

Posted in 2000

Steve burk — Sun, 13 Feb 2000 15:45:54 GMT — source: Informix-list mailing list archive (1991-1998)

Does anyone know how you get rows of data out a function or stored procedure? Do you have to use a fetch?

↪ replying to Steve burk

Jonathan Leffler — Mon, 14 Feb 2000 00:20:53 GMT — source: Informix-list mailing list archive (1991-1998)

Steve burk wrote: > Does anyone know how you get rows of data out a function or stored > procedure? Do you have to use a fetch? Yes. In ESQL/C, you declare a cursor for the statement, then open it, repeatedly fetch, and close it. Ditto in I4GL, etc. DB-Access does this for you automatically. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN #include <disclaimer.h>