Re: SPL question (fwd)

Posted in 1996

Dennis Pimple — 14 Jan 1996 01:17:46 GMT — source: Informix-list mailing list archive (1991-1998)

Jack Parker (jparker@hpbs3645.boi.hp.com) wrote: : > : > Can you generate and execute an SQL statement on the fly inside of SPL? : Any thoughts? I think not, but I seem to remember something being discussed : along these lines in hte not too distant past. No, there is now way to PREPARE or build an SQL statement from a string in SPL. Informix stored procedures are pre-compiled (or compiled at CREATE time, if you will), which I suppose precludes PREPARE. IMO, this is number 2 on my personal feature request list for SPL, after being able to use variables to reference embedded stings. ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Principal Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.