Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

select with no column headings

3 posts in Windows NT Last posting was on 2001-05-10 05:31:29.0Z
Thuc Posted on 2001-05-08 05:02:30.0Z
Reply-To: "Thuc" <tdo@elders.com.au>
From: "Thuc" <tdo@elders.com.au>
Subject: select with no column headings
Date: Tue, 8 May 2001 14:32:30 +0930
Lines: 9
Organization: Elders
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <i7#Ap831AHA.160@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 203.38.229.146
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:787
Article PK: 1087395

Hi,

When doing a SELECT, is there a way of telling it just to produce the
results without any column headings (or accompanying underlines) at all?

Thanks,
Thuc


Manish Patel Posted on 2001-05-08 12:35:42.0Z
From: "Manish Patel" <manishbpatel@hotmail.com>
References: <i7#Ap831AHA.160@forums.sybase.com>
Subject: Re: select with no column headings
Date: Tue, 8 May 2001 08:35:42 -0400
Lines: 24
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <oVyt5471AHA.254@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: gfd.com 208.249.143.82
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:781
Article PK: 1087388

You can specify -b option as follows :

isql -b -Usa -Smy_server


Manish

P.S. - I assume you are not using open client 10

Thuc wrote in message ...
>Hi,
>
>When doing a SELECT, is there a way of telling it just to produce the
>results without any column headings (or accompanying underlines) at all?
>
>Thanks,
>Thuc
>
>


Thuc Posted on 2001-05-10 05:31:29.0Z
Reply-To: "Thuc" <tdo@elders.com.au>
From: "Thuc" <tdo@elders.com.au>
References: <i7#Ap831AHA.160@forums.sybase.com> <oVyt5471AHA.254@forums.sybase.com>
Subject: Re: select with no column headings
Date: Thu, 10 May 2001 15:01:29 +0930
Lines: 15
Organization: Elders
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <3eyOOWR2AHA.254@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 203.38.229.146
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:766
Article PK: 1087373

Thanks Manish!

"Manish Patel" <manishbpatel@hotmail.com> wrote in message
news:oVyt5471AHA.254@forums.sybase.com...
> You can specify -b option as follows :
>
> isql -b -Usa -Smy_server
>
>
> Manish
>
> P.S. - I assume you are not using open client 10