Prior to ASE 12.5, var/char() datatypes (columns or @variables) were
limited to 255 characters.

With ASE 12.5 the limit on var/char() datatypes was increased from 255 to
16296.

My hunch is that somewhere under the hood these limitations play into what
you're seeing.

Chris wrote:

> Mark A. Parsons wrote:
>
>> I think I see what you're talking about.
>>
>> I ran the same 'select' statement (see below) on different ASE servers
>> ... 11.9.2, 12.0.0.8, 12.5.0.3, 12.5.3.
>>
>> I used the same version of isql (12.5.1) with '-w1000'.
>>
>> On the 11.9.2 and 12.0.0.8 ASE's the output was cut off at 255
>> characters.
>>
>> On the 12.5.0.3 and 12.5.3 ASE's the output was *not* cut off.
>>
>> Which version of ASE are you running? (select @@version)
>
>
> I use 12.0.0.x, then it migth be the reason.
> I think the view is a good idea.
> Otherwise, I could use many fields (F1, F2, F3,...) (without
> concatening). But I will have to reformat the lines in shell (or awk)
> Many thanks for your time...