Re: Using SQL output in shell scripts

That's what I've been trying to do also but it's fairly messy. I wanted to avoid the intermediate file. Thanks!

...Mike

"andrija" <ar35644_at_fer.hr> wrote in message news:a1bu57$32i8$1_at_as201.hinet.hr...
> > What is the easiest way to use the output of a SQL statement in a shell
> > script? I would like to be able to send an e-mail to tech support
 whenever
> > the row count of a specific table exceeds a threshold value. Any help is
> > appreciated.
> >
> > ...Mike
>
> I was doing something like that (sending mail from shell scripts). I did
 the
> standard spool into a file, and then a lot of grep, awk, tail, head and
> stuff like that to get the required information, so I can decide wether to
> send mail. But, that's not very good approach. Now I always send mail from
> procedure from database.
>
>
Received on Mon Jan 07 2002 - 15:30:38 CET