Shell Programming and Scripting

!/bin/ksh
set -x
##SID="$1";
##SIDQ="@${SID}";
##ORACLE_SID="@${SID}";
# set database name
SID=$ORACLE_SID;
LOWER_SID=`echo $ORACLE_SID | tr "[A-Z]" "[a-z]"`
USER=$BANUID;
#----------------------------------------------------------------------------------
# Set up script specifics
MPATH=$BANNER_HOME;
 
# Set user for sqlplus activation
SQUID="faismgr_job";
# set password utility
PW_SHL="/u02/sct/xxxxx/xxxx/pw_read.shl";
JOBNUM=$ONE_UP;
AT_SIGN="@";
 
# set job name
JOBNAME="rypidoc"
# set home directory path
MPATH=$BANNER_HOME;
MAILING_LIST="rxxxx@xxxxx.edu"
SCRIPT_PATH="${MPATH}/xxxx/plus/"
SQL_SCRIPT1="rypidoc_loadcss_run.sql"
SQL_SCRIPT2="rypidoc_process2_run.sql"
 
#rm idochd1.lst htfn1.file htfn2.file 2> /dev/null
##:WQSection Two - Identify file(s) to process, process and rename
cd "${MPATH}/middlebury/dat_files"
#Determine if there is a file to process
ls 3526*.dat > /dev/null 2>&1 
if [ $? != 0 ] 
then 
exit
fi
for i in 3526*.dat 
do
 
# Capture just the file sequence number 
fseqno=`print $i | sed 's/.*_//' | sed 's/.dat//' `
cd "${MPATH}/xxxxx/dat_files"
echo $i `date` > idochd1.lst
cp $i idoc.dat
cp $i finaid.idoc
# Load file into tables RYRIDOC_COVER, RYRIDOC_IMAGE, RYRIDOC_TAXDATA, RYRIDOC_W2
# Change dir to where the sql scripts are
cd ${SCRIPT_PATH}
###$PW_SHL $SQUID | sqlplus -s ${SQUID} ${AT_SIGN}${SQL_SCRIPT1} $fseqno ${JOBNUM} ${JOBNAME} ${USER} >>${LF1} 2>>${LF2}
$PW_SHL $SQUID | sqlplus -s ${SQUID} ${AT_SIGN} ${SQL_SCRIPT1} $fseqno ${JOBNUM} ${SID} ${PROC} >>${LF1} 2>>${LF2}
# Process 
cd ${SCRIPT_PATH}
$PW_SHL $SQUID | sqlplus -s ${SQUID} ${AT_SIGN}${SQL_SCRIPT2} ${JOBNUM} ${JOBNAME} ${USER} >>${LF1} 2>>${LF2}
cd "${MPATH}/middlebury/dat_files"
mv $i $i.processed
#Notify User
###asysmail idoc.mail "CSS IDOC file received and processed" $SOFTPATH/log/rypidoc_process2.log
### echo "\nEmail sent to ${MAILING_LIST} Loading Process Finish." >>${LF1} 2>>${LF2}
# Find the last error file for each type
tfn1=$( ls -1t ${MPATH}/XXXX/dat_files/idoc_nomatch* | grep -v BAN1bat| head -1 )
#Determine if tfn1 has any records-if so, send
count=`cat $tfn1 | wc -l `
if [ $count != 0 ]
then
cat ${MPATH}/XXXXX/dat_files/idochd1.lst $tfn1 > ${MPATH}/XXXX/dat_files/htfn1.file
##asysmail idoc.mail "CSS IDOC-No Match File" $SOFTPATH/data/finaid/idoc/htfn1.file
fi
tfn2=$( ls -1t $${MPATH}/XXXXX/dat_files/idoc_error* | grep -v BAN1bat| head -1 )
#Determine if tfn2 has any records-if so, send
count=`cat $tfn2 | wc -l `
if [ $count != 0 ]
then
cat $${MPATH}/xxxxx/dat_files/idochd1.lst $tfn2 > $S${MPATH}/xxxx/dat_files/htfn2.file
##cd $SOFTPATH/bin
###asysmail idoc.mail "CSS IDOC-Error File" $SOFTPATH/data/finaid/idoc/htfn2.file
fi
done
exit

jet:/u02/sct/banner/banpprd/XXXX/shl$ sh rypidoc24
rypidoc24: #!/bin/ksh: not found

+ SID=PPRD
+ + tr [A-Z] [a-z]
+ echo PPRD
LOWER_SID=pprd
+ USER=
+ MPATH=/u02/sct/banner/banpprd
+ SQUID=fimsmgr_job
+ PW_SHL=/u02/sct/banner/XXXX/pw_read.shl
+ JOBNUM=
+ AT_SIGN=@
+ JOBNAME=rypidoc_shl
+ MPATH=/u02/sct/banner/banpprd
+ MAILING_LIST=recheverri@middlebury.edu
+ SCRIPT_PATH=/u02/sct/banner/banpprd/xxxxx/plus/
+ SQL_SCRIPT1=rypidoc_loadcss_run.sql
+ SQL_SCRIPT2=rypidoc_process2_run.sql
+ cd /u02/sct/banner/banpprd/xxxx/dat_files
+ ls 3526_419184.dat
+ 1> /dev/null 2>& 1
+ [ 0 != 0 ]
+ + print 3526_419184.dat
+ sed s/.dat//
+ sed s/.*_//
fseqno=419184
+ cd /u02/sct/banner/banpprd/xxxxx/dat_files
+ date
+ echo 3526_419184.dat Tue May 4 19:49:27 EDT 2010
+ 1> idochd1.lst
+ cp 3526_419184.dat idoc.dat
+ cp 3526_419184.dat finaid.idoc
+ cd /u02/sct/banner/banpprd/xxxxx/plus/
+ sqlplus -s fimsmgr_job @ rypidoc_loadcss_run.sql 419184 PPRD
+ /u02/sct/banner/xxxx/xxxxx fimsmgr_job (stop here...) 
+