Re: Dynamic SQL in SPL

Posted in 1998

Jonathan Leffler — Wed, 23 Sep 1998 09:15:06 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

On Wed, 23 Sep 1998, Nicole Guffey wrote: > Does anyone know of a way to use Dynamic SQL or Macro Expansion within > Stored Procedure Language? I need to be able to pass all or part (say only > the where clause) of a SQL Statement as a parameter of type varchar to a > stored proc and have it parsed and executed as a SQL Statement. There is no way to dynamic SQL in SPL. Period. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn