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.).

Chris wrote:

> Hello,
>
> I would like to create a flat file from isql, with fields at specific
> positions (I concatenate them : 15 characters field 1 + 32 characters
> field 2 + 5 characters field 3 + ...)
> The file is 500 characters.
> But as soon as I exceed 255 characters, nothing more is displayed :-(
>
> Is it impossible to do such a simple task ?
>
> Thanks in advance.