Which brings me back to my last set of comments:

>> Assuming you *are* using the '-w' flag ... you'll need to post more
>> details ... actual SQL query ... what you're doing out in the OS (eg,
>> isql call, what you're doing with the output, etc.).

Chris wrote:

> Mark A. Parsons wrote:
>
>> Make sure you submit the '-w<width>' flag to isql to make sure output
>> lines are <width> characters wide.
>>
>> (I believe the default is 255 characters; if the result set is longer
>> than 255 characters then the 'overflow' will be printed on a new line;
>> this can lead to some unwanted results if your OS commands aren't
>> expecting the embedded CR/LF's.)
>>
>> Assuming you *are* using the '-w' flag ... you'll need to post more
>> details ... actual SQL query ... what you're doing out in the OS (eg,
>> isql call, what you're doing with the output, etc.).
>
>
> Yes, I use -w, but it's only for the line length, not the field length.
> The SQL query has nothing special, I just concatenate fields at special
> positions in order to build a 500 characters line (1 field) for the file
> (Field 1 : pos 2, Field 2 : pos 16, Field 3 : pos 30 , ...) :
>
> --Field 1-------Field 2-------Field 3------ ...
>
>
> But after position 255, it doesn't work anymore :-(
>