Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011
    Posts
    18

    isql returns columns spilled over multiple rows

    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?

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,353
    Try using -w flag e.g.
    isql -w 1024

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •