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