Re: infoperl (wish list)

Tony Heskett, in your mail you wrote: > > 2. How do you get rid of the count(*) and similar column headings ? > I figure that 2>/dev/null in bourne sh gets rid of "Database > selected" and a lot of that kind of stuff, but if I try > > SELECT COUNT(*) " " FROM foo> > I just get a syntax error (idea is just to blank out the > heading, of course). Am I missing something really obvious ? > I ended up piping the output thru egrep -v 'count(*)|^$' to > cut the headings and the blank lines. > Try this... isql dbname - <<! 2>/dev/null output to pipe "nawk 'nawk command(s)'" without headings select count(*) from tabname;! DAS -- David A. Snyder @ UE&C - Catalytic in Philadelphia, PA UUCP: ..!uunet!trac2000!das INTERNET: das@trac2000.ueci.com