Re: ESQL/C V7.10 Trivial Syntax Problem

In all versions of ESQL/C which support stored procedures (5, 6, 7, etc), it has been possible to pass variables as parameters into stored procedure statements: EXEC SQL BEGIN DECLARE SECTION; int i = 34; EXEC SQL END DECLARE SECTION; EXEC SQL EXECUTE PROCEDURE SomeProcedure(:i); You can also pass them into prepared statements (and this will work with earlier versions of ESQL/C too, if the Engine understands stored procedures at all): EXEC SQL PREPARE p_proc FROM "EXECUTE PROCEDURE SomeProcedure(?)"; EXEC SQL EXECUTE p_proc USING :i; You can also use descriptors, etc. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: mschultz@cix.compulink.co.uk ("Martin Schultz") >Date: Tue, 14 Nov 1995 01:05:52 GMT >X-Informix-List-Id: <news.18830> > >I am awaiting delivery of ESQL/C V7.10 - can someone tell me if it is >possible to pass parameters into a stored procedure from an ESQL/C >variable as this is not the case with V5 ? > >The fact is that I can't wait for the documentation as Informix are often >slow to deliver ! > >mschultz@cix.compulink.co.uk