Shell Programming and Scripting

 while IFS='[,]' read locationinp sales; 
do
location_id=`echo $locationinp | cut -d' ' -f2`
cat << EOF > query.sql
select count(*) into :loc_count from location_count where location_id=$location_id and sales=$sales;
EOF
sqlplus DATABASE_OWNER/PASSWORD@CONNECTION_DETAILS < query.sql > output.txt
loc_count=`cat output.txt`
if [[ $loc_count > 1]]; then
echo "delete from location_count where location_id='$location_id' and sales=$sales;" > query1.sql
fi
sqlplus DATABASE_OWNER/PASSWORD@CONNECTION_DETAILS < query1.sql > output1.txt
done < "Input_file"

out=`cat value.txt`
echo $out
if [[ $out = 0 ]];

case $location_id in
CHENNAI|BANGLORE)
function_out PUT_BANGLORE_CHENNAI_COUNT $location_id $sales;;
SALEM|TRICHY|madurai|tich|hfjfj)
function_out PUT_OTHER_location_COUNT $location_id $sales;;
TIRUPUR)
function_out PUT_UNIT_location_COUNTi $location_id $sales;;
*)echo "its not in the code";;
esac

out=`cat value.txt`
echo $out
if [[ $out = 0 ]];
then
sqlplus -S xxx/uyyynen@xxxdbt <<EOF
        SET head off
        SET serveroutput on
        spool value1.txt
select PUT_UNITS.PUT_TRT(&location_id,&sales) from dual;
spool off
spool value2.txt
select PUT_UNITS.PUT_UNIT(&location_id,&sales) from dual;
spool off
exit
EOF
fi
chk2=`cat value1.txt'
chk3=`cat value2.txt'

if [[ $out = 1 && $value1 = 1 && value2 = 1 ]];
then
echo "ll"
mailx -s "JOB SUCESS" ramesh.kumar@pepsiwide.com < /dev/null
else
echo "jf"
mailx -s "JOB FAILURE" ramesh.kumar@pepsiwide.com < /dev/null
fi

function_out()
{
function=$1
location_id=$2
sales=$3
echo $function
sqlplus -S xxx/uyyynen@xxxdbt <<EOF
        SET head off
        SET serveroutput on
        spool value.txt
        select PUT_UNITS.$function('$location_id',$sales) from dual;
        spool off
 exit
EOF
}