UNIX for Dummies Questions & Answers

#!/bin/sh
date_str=`date "+%Y%m%d%H%M%S"`
errfile=ABC_err_$date_str.log
FileDate=12212011
echo Script $0 started at `date` >${errfile}
###Check for the Trigger_file
if ! [ -f "ABC_Trigger_$FileDate" ]
then
        echo "ABC_Trigger_$FileDate doesn't exist" >>${errfile}>&2
Actual_Date=`ls ABC_Trigger_* | sort -t"_" -k3.8 | head -1 | cut -d"_" -f3`
echo $Actual_Date
Date_of_file=$Actual_Date
echo "ABC_Trigger file is ABC_Trigger_$Date_of_file"
else
Date_of_file=$FileDate
fi
####Connect to DB to get the file name###########
SOURCE_FILE_NAME=`sqlplus -s <<sqlEOF
unageq1/pa23403sw@DEVDB
set feedback off
set heading off
set pagesize 0
set echo off
whenever sqlerror exit failure
whenever oserror exit failure
select SOURCE_FILE_NAME||'_$Date_of_file' from source_sys_det WHERE Source_sys_name='ABC' ;
sqlEOF`
echo $SOURCE_FILE_NAME

####transposing the file name and creating a file to check if they are available####
awk '$1=$1' RS= FS="\n" OFS=, $SOURCE_FILE_NAME >>SOURCE_FILE_NAME_LIST


ERR=0
for FILE in $SOURCE_FILE_NAME_LIST
do
if ! [ -f "$FILE" ]
then
        echo "$FILE missing" >>${errfile} 2>&1
        ERR=1
fi
 
done

exit $ERR