Row width and Column separator in Sybase isql

Thursday, May 09, 2013 isql , sybase 0 Comments

Many of you either donot know or perhaps you are not aware of these since there is very less documentation available in google search for these

In general I use:

isql -U<user> -P<passsword> -D<dbname> 

There are two ioptions in isql.
which are

 -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