Can anyone tell me how to remove extra information like header and
footer information from an output of a query?
Any help will be greatly appreciated
TIA

i think i got it. The isql - option takes care of the header info.
still i didnt found any parameter for footer part in isql. any help?

Perhaps "set nocount on"?

Try -b option with set nocount on
isql -Usa -Sserver -b << eof
set nocount on
go
command
go
eof

surajkumar1@gmail.com schrieb:
Try -b option with set nocount on

isql -Usa -Sserver -b << eof
set nocount on
go
command
go
eof

or:

isql -U<login-P<pass-D<databae-S<server<<SQL | grep ""
select "", column1, column2
from table
go
SQL

or use awk/cut to process results instead of grep.

thanx for the reply. one more thing, -b option in isql takes care of
the header part. is there any parameter that we
can define with the isql that takes care of footer also.
of course we can use nocount to do this. just wanted to know any
parameter that we can define with isql to do this?
just curious.

TIA

There is no ISQL parameter to remove the rowcount from the display.
-bret

Thnx.