Shell Programming and Scripting

ERC  DML
  Closure  Date
  ER  DML
  SAP Transfer  Date
   
  APL  DML
  Release  Date
  JP  DML
  SAP Transfer  Date
    07JM200193   
  23/04/2012
  07JM200193ER
  23/04/2012
   
  07JM200193_APL
  25/04/2012
  07JM200193JP
  25/04/2012

          #!/bin/sh
        # erc.log :-    ERC DML output
        # apl.log:-     APL DML output
        # apl_task.log :-APL Planner output
        # jp.log:-      JP Loding output
        # ER.log:-      ER loading output
        # final_mail.sh = sap_header.txt + report.log + sap_footer.txt
       export ORACLE_HOME=/user/oraclnt/8.1.7
        export ORACLE_SID=PLMJD
        export DB_VENDOR=ORA
        export LOCAL=PLMJD
        export TWO_TASK=PLMJD
        export VC_HOSTNAME=plmjox01
        export PATH=/user/oraclnt/8.1.7/bin:/usr/bin:/usr/java2/bin:/sbin:/user/cmitc4/bin:.:/misc/plmclient/bin:$PATH
        export LD_LIBRARYN32_PATH=/user/oraclnt/8.1.7/lib32:$MTI_ROOT/bin:/usr/java2/lib32/sgi
        export OPNLDFLAGS='-O -L/user/oraclnt/8.1.7/lib32'
        export ORALIBS=/user/oraclnt/8.1.7/lib32/libclntsh.so.8.0
        export LOCATION="/user/omfprod/archana/sap_notification"
        final_mail=$LOCATION/final_mail.sh
        cd $LOCATION
        $LOCATION/erc.sql "$1" "$2"                       >erc.log
        echo ""
        echo "* * * * * * * * * * * ERC DML Ends * * * * * * *" >>erc.log
        :>apl.log
        for line in `cat erc.log|grep -i "erc"|awk '{print $1}'`
        do
             $LOCATION/apl.sql $line                       >>apl.log
        done
        echo
        echo "* * * * * * * * * APL  DML Ends * * * * * * * * *" >>apl.log
        :>apl_task.log
        for line in `cat erc.log|grep -i "erc"|awk '{print $1}'`
        do
                $LOCATION/apl_task.sql $line                       >>apl_task.log
        done
        echo
        echo "* * * * * * * * * APL TASK FOR PLANNER Ends * * * * * * * * *" >>apl_task.log
        :>jp.log
        for line in `cat erc.log|grep -i "erc"|awk '{print $1}'`
        do
                $LOCATION/jp.sql $line                       >>jp.log
        done
        echo
        echo "* * * * * * * * * SAP LOADING OF JP DMLS * * * * * * * * *">>jp.log
        :>ER.log
        for line in `cat erc.log|grep -i "erc"|awk '{print $1}'`
        do
                $LOCATION/ER.sql $line                       >>ER.log
        done
        echo
        echo "* * * * * * * * * SAP LOADING OF ER DMLS * * * * * * * * *">>ER.log
       cat erc.log >report.log
        cat apl.log >>report.log
        cat apl_task.log >>report.log
        cat jp.log >>report.log
        cat ER.log>>report.log
        cat sap_header.txt >>$final_mail
        cat report.log   >>$final_mail
        cat sap_footer.txt >>$final_mail
        chmod 700 $final_mail
        $final_mail
        exit 0