Re: Informix Stored Procedures
Posted in 1997
Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL
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. >\