Shell Programming and Scripting

home/unix>cat test.txt
DAILY.JOB CHENNAI,8388
DAILY.JOB BANGLORE,3848
DAILY.JOB TRICHY,9489
DAILY.JOB TIRUPUR,8409

while read word
do
location_id=`awk -F '[ ,]' '{print $2}' $word`
sales=``awk -F '[ ,]' '{print $3}'$word`
  case $location_id in
    chennai|banglore)
      function_value_1($location_id,$sales) ;;
      function_value_1 put_area_loc_value ;;
    salem|trichy||kovai)
      function_record_delete ;;
      function_value_1($location,$sales) ;;
    tirupur)
      function_record_delete ;;
      function_value_1($location,$sales) ;;
    *)
      echo "location is out of the range $location_id" ;;
  esac

while read word
do
sales=echo "$word" | cut -d',' -f2
lot=echo "$word" | cut -d' ' -f2
locaton_id=echo "$lot" | cut -d',' -f1

  case $location_id in
    chennai|banglore)
      function_value_1($location_id,$sales) ;;
      function_value_1 put_area_loc_value ;;
    salem|trichy||kovai)
      function_record_delete ;;
      function_value_1($location,$sales) ;;
    tirupur)
      function_record_delete ;;
      function_value_1($location,$sales) ;;
    *)
      echo "location is out of the range $location_id" ;;
  esac

#!/bin/bash

while IFS='[, ]' read job location sales; do
    echo $location
    echo $sales
done < test.txt

if [[ $loc_count > 1]]; then

cat shell.sh
#!/bin/sh
while IFS='[,]' read locationinp sales; do
location_id=`echo $locationinp | cut -d' ' -f2`
sqlplus -S /NOLOG << EOF
CONNECT xxxx/password@xxxxdbt
set echo off
set heading off
set feedback off
set pagesize 0
CONNECT xxxx/password@xxxxdbt
SET head off
select count(*) into :loc_count from location_count where location_id='$location_id' and sales=$sales;

if [[ $loc_count > 1]]; then

delete from location_count where location_id='$location_id' and sales=$sales;

exit

EOF

done < queryout.txt

 if [[ $loc_count > 1]]; then
 delete from location_count where location_id='$location_id' and sales=$sales;
 exit
 fi

home/unix>cat bit.txt

                                             1


Output :
+ + cat bit.txt
out=
                                             1
+ [[
                                             1                                   = 1 ]]
+ echo failire

code

out=`cat chkbit.txt`
if [[ $out = 1 ]];
then
echo "sucess"
else
echo "failure


sqlplus -S xxx/yy@db <<EOF
        SET head off
        SET serveroutput on
        spool bit.txt
        select package.metric_function('$location_id',$sales) from dual;
        spool off
exit
EOF