UNIX for Dummies Questions & Answers

#
#
# Control the Unix processing cycle for uploading
# M+S Nomiated Delivery Days into the E2E database.
#
# 1.0  AM  13/09/2013  Initial Version
#
set +xv
 
# Execute the .profile (coz cron doesn't)
. ~/.profile
 
# Library functions
. $( dirname $0 )/common_functions.ksh
 
THIS=$( basename $0 )
 
fn_banner "Process M+S Nominated Delivery Days files"
 
echo "Starting: $(date)"
fn_writeTrace "starting"
 
 
# Local variables
bookmark="10"
TODAY=$(date "+%Y%m%d")
D_EXTTAB=/e2e_ms_xfer
MASK=e2e_ms_edd_nom*
D_WORK=$XFMSC
D_DONE=$XFMSZ
JOBNAME=$( echo $THIS | cut -f1 -d. )
 
 
fileCount=0
 
# Oracle
bookmark="20"
fn_oraenv
 
# Good to go
bookmark="30"
runControl=1
 
 while [ $runControl -eq 1 ]
 do
   cd $D_WORK
 
 
     # Are there any files?
    bookmark="35"
    fileFound=0
    ls -1 $MASK > /dev/null 2>&1
    if [ $? -eq 0 ]
    then
        # Oldest file
        bookmark="37"
        fileName=$( ls -1 $MASK | head -n 1 )
        mv filename e2e_ms_edd_nom.csv
 
        let fileCount=fileCount+1
        fileFound=1
 
       # Move the file to where the ext.tables expect
        bookmark="40"
        mv $XFMSC/e2e_ms_edd_nom.csv $XFMS
 
        # Invoke the Oracle process to upload the data
        #
        bookmark="50"
        fn_oraenv
        sqlplus $OCS @$SQL/exec_pull_nom_del_date.sql
 
        # Move the file to 'done'
        #
        bookmark="60"
        mv $XFMS/e2e_ms_edd_nom.csv $XFMSZ
       
     fi # file found
 
 
    fn_setHeartbeat $JOBNAME
 
done # while
 
# All done - Cleanup and exit
#
bookmark="70"
fn_cleanup
echo "Complete: $(date)"
fn_writeTrace "complete"
 
exit 0

mv filename e2e_ms_edd_nom.csv

mv "$filename" e2e_ms_edd_nom.csv