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.

DB: Informix 10