Howdy,
Is there a way to issue a select statement in a scripts and based on what is
returned perform a different action.
My idea is to issue the following select
"select CACHE_HIT_PCT from db" if the value is below 98.5 then issue message
i "DB cache hit rate too low. Bump up bufpoolsize"
If this is possible in a script there are a lot of other funky things I'd
like to do.
P.S. I have done it via a ksh and perl but would like to avoid it.


Share and Enjoy

Wayne Gorton
Innovative Business Knowledge (IBK) P/L
PH:    +61 2 9614 1604
FAX: +61 3 9820 2840
MOB: +61 417 427 441
Email: waynneg AT ibk.com DOT au


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.380 / Virus Database: 213 - Release Date: 24-Jul-02