How many UNIONs can i use in a single query?

[daYorkie]

Hi all,

I have a rather long query selecting items out of various unconnected areas of the DB. I have a working query including 20 UNIONs but when I add the 21st I am presented with a syntax error DB Errorcode=-201 (standard general syntax code)

each statement in isolation runs fine.

Have i hit a hard limit on number of union allowed? Or is this something i may be able to work around / reconfigure? Appreciate I'll probably be advised to write a better query but the data really is unconnected so I do not see a solution to get all the data onto a single report without using UNION.

Thankyou

 

[kray4660]

I have never heard of such a limit. Unfortunately because of the different versions of Informix and the tools to build the queries, it would be difficult to be for sure. I would suggest breaking down the query into a smaller query and testing (particularly the area you are having an issue with).

 

[daYorkie]

thanks kray - I will run each segment of query and put output of each into a new temp table and select everything from that once done. Pain but'll do the job and avoid the unions.