Dynamic SQL in SPL

Posted in 1998

Nicole Guffey — Wed, 23 Sep 1998 10:46:47 -0500 — source: Informix-list mailing list archive (1991-1998)

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. Thank you, Nicole Guffey DBA J. Driscoll & Associates nguffey@jdriscoll.com