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.