Re: [U2] Reporting Tools

As a work around, would this work:
* produce file1 with record key and then 100+ data fields
* produce file2 with remaining data fields
* execute Linux command:
   paste file1 file2 >myrealdata.csv




David Rotman, Ph.D.
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
[email protected]
voice 937-766-7905
fax 937-766-8819



On Mon, Mar 3, 2014 at 3:34 PM, jeffrey Butera <[email protected]>wrote:

> On 3/3/14, 3:21 PM, Jeff Schasny wrote:
>
>> Jeff,
>>
>> What I think many of us are suggesting is essentially "if it hurts when
>> you do that, don't do that" i.e. if the query language won't accomplish
>> what you want to do, use something else.
>>
>
> Jeff
>
> Believe me - I hear you (and others).  But my administration isn't
> listening because they all think this is a reasonable request ("excel can
> handle 200+ columns").   So if I can't make this work in Unidata I'll have
> to move to MSSQL which I really, really, really don't want to do.
>
> At this point I'm just trying to understand the limit on the number of
> fields in a LIST statement.  I know in my case that it's not a sentence
> length issue as I might've thought earlier so I'd like to know what is
> causing this (with the understanding that I very well may not be able to
> solve this).
>
> Jeff
>
>
>
>
>> jeffrey Butera wrote:
>>
>>> On 3/3/14, 2:58 PM, Brian Leach wrote:
>>>
>>>> Jeff
>>>>
>>>> Try mvQuery, that should not have any problems with those volumes.
>>>>
>>>
>>> Hi Brian
>>>
>>> We've isolated the problem to Unidata itself, not the reporting tool.
>>>  In short, when we do a LIST with about 150 fields, it throws:
>>>
>>> "too many items in LIST"
>>>
>>> As soon as we erase a field (any field), the LIST statement runs
>>> properly.  Unfortunately, I cannot locate any parameter that might control
>>> this.  I thought we were hitting U_SENTLEN - but we're nowhere near that
>>> value.
>>>
>>>
>>>
>>>
>>
>
> --
> Jeffrey Butera, PhD
> Associate Director for Application and Web Services
> Information Technology
> Hampshire College
> 413-559-5556
>
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users