RE: Yes Virginia. Dynamic SQL in SPL is possible.

What the performance hit??? Oh and that just saved me a load of work, I just started writing one:-)) Paul Watson # WFSoftware Ltd # If it was easy Tel: +44 1436 674729 # everybody could Fax: +44 1436 678693 # do it www.wfsoftware.com/informix # -----Original Message----- From: Paul Brown [mailto:paul.NOSPAM.brown@informix.com] Sent: Monday, April 03, 2000 7:45 PM To: informix-list@iiug.org Subject: Yes Virginia. Dynamic SQL in SPL is possible. About the #4 most FAQ in this list is "How do I write a query in SPL when I don't know the table/column name/have a different predicate?" Well, I wrote an extension that works in IDS.2000/IIF.2000 to let you do this. If you want to take advantage of it, you're going to have to upgrade, I'm afraid. It's available from: http://www.iiug.org/software/index_ORDBMS.html The README link on that page describes what it does.