Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supressing Column headings from sql output

Status
Not open for further replies.

88Pete88

Programmer
Aug 9, 2005
2
Does anybody know a way to supress column headings from sql output? For example:
isql -s storedb<<EOF
select cname, cust_id
from customer
EOF

would return

cname cust_id

Joe 1234
Larry 4325
Curly 34123


I want only to get the data and exclude everything else.

Thanks!
 
You can send the output to a file without the headings:

Code:
isql -s storedb<<EOF
output to "/tmp/temp.txt" without headings
select cname, cust_id
from customer
EOF
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top