Re: Eleven FAQ's About comp.databases.informix and informix-list@iiug.org

Posted in 2005

Mike Aubury — Fri, 13 May 2005 16:33:47 +0100 — source: Usenet: comp.databases.informix

For completeness - it's also supported by Aubit4GL :-) On Friday 13 May 2005 14:07, Doug Lawry wrote: > David, > > I have just read the new FAQ entries, one of which is: > > 4.1.36 How can I use a stored procedure from 4gl? > > On 18th July 2001 NOahammSPAN@sanderson.net.au (Andrew Hamm) wrote:- > > >> LET lc_MySP = "EXECUTE PROCEDURE proc_name(?, ?, ?)" > >> PREPARE Prep_MySp FROM lc_MySp > >> EXECUTE Prep_MySp USING parameter1, parameter2, parameter3 > > The following is supported in 4GL 7.3 and Four J's, and is rather easier: > > SQL > EXECUTE PROCEDURE proc_name($parameter1, $parameter2, $parameter3) > END SQLsending to informix-list