• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 808
  • Last Modified:

How to suppress headers (columns names and underlines) of SQL statements?

Hi,

I have to create a text flat file running Sybase script from DOS using isql utility.

How to suppress headers (columns names and underlines) of SQL statements?

Thanks.
0
GoodName
Asked:
GoodName
1 Solution
 
grant300Commented:
I don't believe there is a way to do this in ISQL.

There is, however, an open source alternative to ISQL called SQSH.  It is enormously feature rich and I would be very surprised if it did not give you a way to turn off the headers.  You will find it a great addition to your tool box.

You can download it from www.sqsh.org

Regards,
Bill
0
 
GoodNameAuthor Commented:
Thanks for the interesting utility. I'll look at it in details.

I have found how to suppress columns headers:

isql -b ....

But thank you any way for the link. I might use SQSH instead!

Kind regards.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now