RE: Dynamic SQL in STored Procedures

Yes if you have 9.2x and the Paul Browns Dynamic SPL Blade (www.iiug.org) You still can't do dynamic drop tables otherwise No Paul Watson # WF Software Ltd # Please don't Tel: +44 1436 674729 # confuse me with Fax: +44 1436 678693 # someone who cares www.wfsoftware.com # > -----Original Message----- > From: Andy H [mailto:lokidb@hotmail.com] > Sent: Tuesday, November 28, 2000 9:22 AM > To: informix-list@iiug.org > Subject: Dynamic SQL in STored Procedures > > > Hi > > > I have a question, if anyone can answer it. > > > I have a stored procedure that has a number of parameters > passed to it. Some > or all of these parameters are used in the WHERE clause of > the SELECT > statement on a FOREACH loop. > > > I was wondering if it was possible to build the SQL statement > dynamically in > SPL to improve the performance when SELECTing from the > database ie the > WHERE clause would only use those parameters that have a > value specified > for them. > > > Thanks in advance > > > Andy H > > > ______________________________________________________________ > _______________________ > Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com ********************************************************************** The contents of this e-mail are confidential to the ordinary user(S) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. **********************************************************************