Unanswered: Using InfoSphere Solution Answer Queries and Informix
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.