Shell Programming and Scripting

pSec=$1
pLoopCnt=$2

$ ksh sfs_pcard_load_file.ksh 30 3
ERROR: Required Parameters Missing.
USAGE: sfs_pcard_load_file.ksh

#!/usr/bin/ksh
#
# Check for required number of parameters if any are expected
#--------------------------------------------------------------------
#
if [[ $# != 0 ]]; then
  print "ERROR: Required Parameters Missing."
  print "USAGE: `basename $0`"
  exit 1
fi
#
#####################################################################
#
# Initialization file
#--------------------------------------------------------------------
. ./pcard_load_data.ini

#####################################################################
#
# Parameter definition
#--------------------------------------------------------------------
pSec=$1
pLoopCnt=$2
#
#####################################################################
#
# Variable Initialization
#--------------------------------------------------------------------
#
CURDATE=`date +%m/%d/%Y" "%H:%M:%S`
#LOGDATE=`date +%m%d%Y"_"%H%M%S`
LOGDATE=`date +%m%d%Y"`
JOBNAME=`basename $0 | cut -d. -f1`
LOG_FILE=${LOG_DIR}/${JOBNAME}_${LOGDATE}.log
LOG_FILE_ERROR=${LOG_DIR}/${JOBNAME}_${LOGDATE}_err.log
ORALOGFILE=${LOG_DIR}/PCARDDAILY${LOGDATE}.log

# log file header
echo "+------------------------------------------------------------+" >> $LOG_FILE
echo "This is the log file of pcard_load_file.ksh script"  >> $LOG_FILE
echo "Run date: $CURDATE\n" >> $LOG_FILE

#
#####################################################################
#
# Step: 1
#
# Check for already running process and any files to process
#
#--------------------------------------------------------------------
#
echo "Step 1 Start..." >> $LOG_FILE
ctr=0
while [ ${ctr} -lt ${pLoopCnt} ] 
do
  ISRUNNING=`ps -eaf -o args | grep -i sfs_pcard_load_file.ksh | grep -v grep | wc -l`
  ctr=$(($ctr + 1))
  if (( ${ISRUNNING} > 1 )); then
    echo "ERROR: Process is already running." >> $LOG_FILE
    echo "Please Contact Application Administrator" >> $LOG_FILE
    sleep $pSec
    echo "number of attempt $ctr" >> $LOG_FILE
    #exit 1
    if ((${ctr} == ${pLoopCnt})) then
      exit 1
    fi
  else
    exit 0
  fi
done
#
NUMFILES=`ls -1 $INPUT_DIR | wc -l`
 if (( ${NUMFILES} == 0 )); then
   echo "WARNING: There are no files in input directory to process.\n" >> $LOG_FILE
   exit 1
 fi
echo "End of Step 1\n" >> $LOG_FILE
#
#####################################################################
#
# Step: 2
#
# Process files in INPUT_DIR
#
#--------------------------------------------------------------------
#
echo "Step 2 Start...\n" >> $LOG_FILE
cd $INPUT_DIR
#
NUMFILES=`ls -1 *.csv | wc -l`
 if (( ${NUMFILES} == 0 )); then
   echo "WARNING: There are no files in process directory.\n" >> $LOG_FILE
   #if there are no input files there will be no output file to be created
   #needs to create a null output file
   cp pcard.null PCARDDAILY${LOGDATE}.txt
   echo "         Created the $INPUT_DIR/PCARDDAILY${LOGDATE}.txt null file to replicate the required file.\n" >> $LOG_FILE
   #needs to create a database log file PCARDDAILY${LOGDATE}.log
   echo "WARNING: There are no extracted files.\n" >> $ORALOGFILE
   exit 0
 fi
#
 for filename in $(ls -1 *.csv)
 do
  echo "Processing $filename \n" >> $LOG_FILE
  #
  echo "Copied $filename to log directory: $LOG_DIR\n" >> $LOG_FILE
  cp $filename $LOG_DIR
  #
  echo "Executed PL/SQL package for $filename\n" >> $LOG_FILE
  SQL_LOG_FILE=${LOG_DIR}/${filename}_${LOGDATE}.log
  DB_RSLT=`sqlplus -s <<EOF >> $SQL_LOG_FILE
   $USERID
   --set head off
   --select '$filename' from dual;
   --set serveroutput on
   declare
    v_result varchar2(200);
   begin
    cca_app.Pa_SFS_PCARD_Daily_Bulkload.Pr_Daily_Process('$filename');
   end;
/ 
   exit 0
  EOF`
  wait
  #
  RC=$?
  #
  echo $DB_RSLT >> $LOG_FILE
  echo "Deleted $filename from $INPUT_DIR\n" >> $LOG_FILE
  rm -f $filename
  #
 done
 echo "End of Step 2\n" >> $LOG_FILE

#
#####################################################################
#
# Step: 3
#
# check for file PCard (Output PCARDDAILY*.txt) 
#
#--------------------------------------------------------------------
#
echo "Step 3 Start...\n" >> $LOG_FILE
cd $INPUT_DIR
#
NUMFILES=`ls -1 PCARD*.txt | wc -l`
 if (( ${NUMFILES} == 0 )); then
   echo "WARNING: There are no PCARD*.txt files in the output $INPUT_DIR directory.\n" >> $LOG_FILE
   cp pcard.null PCARD${LOGDATE}.txt
   echo "         Created a PCARD${LOGDATE}.txt null file to replicate the file.\n" >> $LOG_FILE
   exit 1
 fi
#


#
#####################################################################
#
# Step: 4
#
# delete files from log and completed dir > 30 days old   
#
#--------------------------------------------------------------------
#
echo "Step 4 Start...\n" >> $LOG_FILE
#
cd $LOG_DIR
find . -name "*.csv" -mtime +30 -exec rm -f {} \;                 
cd ${LOG_DIR}                                                                  
find . -name "*.log" -mtime +30 -exec rm -f {} \;                 
#
 echo "End of Step 4\n" >> $LOG_FILE
#
exit 0