hi,

I am new to both Informix and InfoSphere and have some questions on how to develop solution answer queries for InfoSphere with a Informix DB. It seems that InfoSphere has some restrictions to how a valid SQL should look like.

There's not been a lot of help in browsing the www for answers and the public IBM documentation has not been very helpful.

In particular, how can I write solution queries with multiple statements (ex: a query using a temp table)?


I hope someone can help or maybe point me in the right direction.
Thanks

---
DB: Informix 10