#!/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