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

Almost all of it is in the query processing. That is, put a slow query into Exec() and you get back slow results. For fast queries it's probably going to be ~20% tops. There are a couple of places to tweak it; particularly memory management (it ships creating 12 byte buffers 'coz that's the fastest way to spot bugs - up this to ~1024 bytes). But that's probably only marginally noticable. At 09:06 AM 4/4/00 +0100, Paul Watson wrote: >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. >