Home > Archive > Sybase Database > April 2006 > Re: Workaround for 'Maximum number of user tables under all sides









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Workaround for 'Maximum number of user tables under all sides
DA Morgan

2006-04-06, 8:23 pm

wgblackmon@yahoo.com wrote:
> I'm creating a query with 46 UNION ALL statements. I'm getting the
> following error message:
>
> Maximum number of user tables under all sides of a UNION statement can
> not exceed 256 Please simplify the query and retry.
>
> The explanation follows:
> Explanation:
> Adaptive Server could not perform the requested action. Rewrite the
> command to conform to the requirement specified in the error message.
>
> I can't simplify the SQL anymore than it already is. Any suggestions
> for a work-around?

Post the DML or at least a representative sample.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com