Hi, rather than using Interactive SQL, I need to use the command line 'isql' client to do some basic queries against the ASE dB. However, the results are returned with each column on its own row. For example, rather than seeing the following.
lastname,firstname,location
murray,john,home
thompson,marry,work

I'm getting the following.
lastname,
firstname,
location

murray,
john,
home

thompson,
marry,
work

Anyone has any idea on how to set it such that it'd display in a nice CSV format?

Try using -w flag e.g.
isql -w 1024