Shell Programming and Scripting

Hey friends, below mentioned script is giving me proper o/p which can be “1” or “2”

echo select status_ac from db_acct where acct_num='$1'" | dbaccess elstest

Now I want to interpret the o/p as follows.
If o/p is 1 then “YES”
If o/p is 2 then “No”
And to do this I have modified above script to:-

select status_ac,
case
when status_ac ="1" then 'Review status is: YES'
when status_ac ="2" then 'Review status is: NO'
end
from db_acct
where acct_num='$1'"

Now its not returning any value...

Is it possible to interpret as I want? I am new to scripts. Please help.

Thanx in advance

Anushree

Hey friends, waiting for reply anxiously since long time...

Please don't 'bump-up' posts - read the rules