Shell Programming and Scripting

#!/bin/ksh
#File contains Only New Records that sent in the Current Load
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/11.2.0
export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$PATH:$ORACLE_HOME/bin

dbfile=/space/dbexport/PHR/data/eligExport.csv

ControlFileNm="/space/dbexport/PHR/control/bene_eligibility.ctl"
logfile="/space/dbexport/PHR/log/bene_eligibility-`date +%Y%m%d`.log"
#COUNT=$(FILECOUNT=$(find /space/dbexport/PHR/data/eligExport.csv -type f -mtime -1 -print | wc -l))
#STATE1="The total number of counts of the input files is: $(COUNT)"
touch $logfile
chmod 777 $logfile
#Checks for any duplicate records in the file
diff -f /space/dbexport/PHR/data/eligExport.csv /space/dbexport/PHR/data/eligExport-20101018.csv
#sort -d -f -u -k 1.${start},1.${end} ${file}
#sort -d -f -u ${file} > ${LOG}
 
#Checks whether the Input file exists. If file found the load process starts else throws error that file not found
if [ -f $dbfile ]
then
echo 'The input file "eligExport.csv" exists, and the data has been loaded'
#mv /space/dbexport/PHR/data/eligExport.csv /space/dbexport/PHR/archive/eligExport-`date +%Y%m%d`.csv
#chmod 777 /space/dbexport/PHR/archive/eligExport-`date +%Y%m%d`.csv
/space/dbexport/PHR/log/bene_eligibility-`date +%Y%m%d`.log ; cat dbfile | wc -l | read linecount ; echo $linecount | to=id11355@noridian.com
basename=`basename $logfile`
subject="BENE ELIGIBILITY TABLE LOAD STATUS"
(echo 'THE INPUT FILE "eligExport.csv" EXISTS AND THE DATA HAS BEEN LOADED' ; uuencode $logfile $basename ) | mailx -s "$subject" "$to"
else
 echo 'The input file does not exist in the folder'
/space/dbexport/PHR/log/bene_eligibility-`date +%Y%m%d`.log | to=id11355@noridian.com
subject="BENE ELIGIBILITY TABLE DID NOT LOAD AS THERE IS NO DATA FILE PRESENT"
(echo 'DATA LOAD FAILED AS THERE IS NO INPUT FILE PRESENT IN THE FOLDER' ; uuencode $logfile $basename ) | mailx -s "$subject" "$to"
fi
if [ $(hostname) = elect ]
then
export userName="zx01182"
export ORACLE_SID=db86
export pwd_file=db86zx01182pw
elif [ $(hostname) = chi ]
then
export userName="zx01204"
export ORACLE_SID=db87
export pwd_file=db87zx01204pw
elif [ $(hostname) = zack ]
then
export userName="zx01205"
export ORACLE_SID=db88
export pwd_file=db88zx01205pw
else exit
fi
/usr/local/pl/util_scripts/perlencrypt.pl -k /export/home/oracle/secure/ealgorithm -d /sdr1/system/$pwd_file | sqlplus $userName @/space/dbexport/scripts/tru
ncate_phr_bene_1.sql
/usr/local/pl/util_scripts/perlencrypt.pl -k /export/home/oracle/secure/ealgorithm -d /sdr1/system/$pwd_file | sqlldr $userName  control=$ControlFileNm log=$
logfile bad=/space/dbexport/PHR/bad/bene_eligibility-`date +%Y%m%d`.bad

 
Message  more message       95 !
SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 19 16:07:37 2010
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
drop index zx01193.bene_elig
                   *
ERROR at line 1:
ORA-01418: specified index does not exist
 
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Password:
SQL*Loader: Release 11.2.0.1.0 - Production on Tue Oct 19 16:07:37 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Commit point reached - logical record count 64
Commit point reached - logical record count 95

echo "Message $variables more message $(wc -l </space/dbexport/PHR/data/eligExport.csv ) !" ; uuencode $logfile $basename  | mailx -s "$subject" "$to"

compare
$( wc -l </space/dbexport/PHR/data/eligExport.csv ) to $( sort -u /space/dbexport/PHR/data/eligExport.csv | wc -l )
echo "Message $variables more message!" ; uuencode $logfile $basename  | mailx -s subject-line abc@gmail.com

 ( echo "Message $variables more message $(wc -l </space/dbexport/PHR/data/eligExport.csv ) !" ; uuencode $logfile $basename ) | mailx -s "$subject" "$to"

cmp $( wc -l </space/dbexport/PHR/data/eligExport.csv ) to $( sort -u /space/dbexport/PHR/data/eligExport-20101019.csv | wc -l )
( echo "Message: $variables The total number of records in the input file is: $(wc -l </space/dbexport/PHR/data/eligExport.csv ) !" ; u
uencode $logfile $basename ) | mailx -s "$subject" "$to"

DUP_RECORDS=$( cat fileA fileB | sort | uniq -d | wc -l )
 
if [[ $DUP_RECORDS > 0 ]]
then
    # mailx command here
fi

for f in fileA fileB
do
 sort $f | uniq -d | wc -l | read DUP_REC_CT
 if (( $DUP_REC_CT > 0 ))
 then
    # mailx command here
 fi
done