In general I use:
isql -U<user> -P<passsword> -D<dbname>
There are two ioptions in isql.
-s Column separator.This wil separate columns with what ever character is followed by this option another option is (and probably very important): -w This will set the row width.By default is set to 80 characters and if the row length exceeds 80 characters, a new line is added in the console output.for eg:
isql -U<user> -P<passsword> -D<dbname> -s ',' -w 65535