Re: Stored Procedures

Posted in 1996

Dennis J Pimple — Sat, 26 Oct 1996 08:54:16 -0600 — source: Informix-list mailing list archive (1991-1998)

Manoj Shroff wrote: > > Dear All, > > Is it possible to reference a variable in a select statement in > a stored procedure, i.e > Afraid not. All the SQL has to be compiled at creation time, thus no PREPARE in SPL, and thus no way to do "generic" SQL statements. //////////////// ======================================================= ////////// // Dennis J. Pimple Informix Software, Inc. ////// / /// Principal Consultant 5299 DTC Blvd Suite 740 ///// // //// dennisp@informix.com Englewood CO 80111 //// // ///// /// // ////// recept: 303-850-0210 // // /////// direct: 303-740-5611 Opinions expressed are mine, / /////////// fax: 303-843-6408 and do not necessarily //////////////// http://www.informix.com reflect those of my employer