Re: Removing ISQL headings
I write :
> > [ ... I can't get rid of the headings isql puts on output ... ]
David Snyder writes back :
> Try this...
>
> isql dbname - <<! 2>/dev/null
> output to pipe "nawk 'nawk command(s)'" without headings
> select count(*) from tabname;> !
Many thanks, just what I wanted. You can catch the output, too :
:
echo 'output to pipe "tr a-z A-Z" without headings
select lname, fname from employee' |isql dbname 2>/dev/null |
pr -2 |
lp
--
Cheers - Tony.
____________________________________________________________________________
Who: Tony Heskett | DHL Systems Ltd, Kings House,
How: theskett@lhr-sys.ssf-sys.dhl.com | Great West Road, Brentford, TW8 9HS
Vox: (+44) 81 747 8330 x 363 | Fax: (+44) 81 747 0875