Re: Informix Stored Procedures

Posted in 1997

David Williams — Sun, 16 Mar 1997 22:41:41 +0000 — source: @@NL@@>THE QUESTIONS:@@NL@@>1. Can a C program, using Informix ESQL/C in dynamic mode, fetch@@NL@@>a result set from Informix Stored Procedures. If so, how can@@NL@@>this be done? (I need one example)@@NL@@>2. Can this be done using CLI? (also need example)@@NL@@>Thanks. --Woodson@@NL@@>this be done? (I need one example)@@NL@@>\

In article <5gbnfp$55p$1@mhadf.production.compuserve.com>, Woodson Martin <73004.2067@CompuServe.COM> writes >I am trying to find out if I can use Informix Stored Procedures >to return a result set like I can with Sybase SQL Server, MS SQL >Server, or now Oracle. I can't find anything on this in the Yes you can - it's probably in the ESQL/C documentation. **** This next bit is from memory - I havn;t tried it but I read it somewhere. **** You can PREPARE p1 from "EXECUTE PROCEDURE x(...)" and then DECLARE CURSOR c1 for p1 FOREACH c1 into var1,var2... .... END FOREACH >informix ODS documention. If anyone who can help with the >following questions, I would really appreciate it. >\