I am getting the following error (trimmed for content):

SQL State: 54010
Vendor Code: -101
Message: [SQL0101] SQL statement too long or complex. Cause . . . . . :
The SQL statement is longer than the limit allowed for length or
complexity. The reason code is 3. One of the following reason codes
indicates the error: 3 - The sum of the lengths of the non-LOB columns in a
select list, table, view definition, or user defined table function is
greater than 32766 or the definition contains a LOB and the sum of the
lengths specified on the ALLOCATE clause for varying-length fields and the
non-varying field lengths is greater than 32740. The maximum length is
reduced if any of the columns are varying-length or allow null values.

Is there any way to get around this? I am trying to create a .NET reporting
services report and have two very long comment fields that are needed in the
view. Breaking it into two views isn't working for this report. Otherwise it
is back to the drawing board.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].