RE: Dynamic SQL in SPL

Posted in 1998

Nicole Guffey — Thu, 24 Sep 1998 08:20:29 -0500 — source: Informix-list mailing list archive (1991-1998)

>In article <6ub6rv$f2t$1@news.xmission.com>, NGuffey@jdriscoll.com (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. > > > > Thank you, > > Nicole Guffey > > DBA > > J. Driscoll & Associates > > nguffey@jdriscoll.com > > > > >You can't do this, but you can dynamically create SPL and then execute it >from inside existing SPL >Paul Watson # I don't suffer from >WF Software Ltd. # stress, I'm just >Tel. (+44) 1436 674729 # a carrier >Fax. (+44) 1436 678693 # >www.wfsoftware.co.uk I'm not sure what you mean, could you clarify? Thank you, Nicole Guffey DBA J.Driscoll & Associates nguffey@jdriscoll.com