The only limit that I am aware of is the limits on the length of a
single SQL statement which is 65535 characters, so if each table and
column name is two characters long that works out to about 3449 SELECTS
in an maximum length UNION less the characters needed to define the VIEW.
Art
Art S. Kagel
Oninit (www.oninit.com <http://www.oninit.com>)
IIUG Board of Directors (art at (no spam) iiug.org <mailto:art at (no spam) iiug.org>)
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Oninit, the IIUG, nor any other
organization with which I am associated either explicitly or implicitly.
Neither do those opinions reflect those of other individuals affiliated
with any entity with which I am affiliated nor those of the entities
themselves.
On Wed, Oct 21, 2009 at 2:34 PM, fandelau <fandelau at (no spam) gmail.com
mailto:fandelau at (no spam) gmail.com>> wrote:
Guys,
Is anyone aware of a limit on the number of select statements that a
union view can handle? I have tested a union view with 100 "select * "
from 100 different tables, with no problem. Just wondering if there is
a ceiling, or if the sky is the limit... ^_^
I'm working on 11.10.FC3 on Solaris.
Thanks in advance!
Ramon.
_______________________________________________
Informix-list mailing list
Informix-list at (no spam) iiug.org <mailto:Informix-list at (no spam) iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
