UNIX for Dummies Questions & Answers

Hi

I have a script that does a select from a table. I want the script to return a 0 status if a specific column has 'OK' value or return 1 if this column returns 'NOT OK'.

The output now is similar to:
COL1 COL2 STATUS
------- --------- -------

I want to be limited to an exit value:

Whenver STATUS has NOT OK, it returns 1
If not, return 0


how to achieve this?

thanks

Code:

$ echo -e "Test\tTest\tNot OK"
Test    Test    Not OK
$ echo -e "Test\tTest\tNot OK"|grep -qv "Not OK$" ; echo $?
1
$ echo -e "Test\tTest\tOK"|grep -qv "Not OK$" ; echo $?
0