Shell Programming and Scripting

#!/bin/sh
set -x
# Check to see if source file path is given
if [ -z "$1" ]
then
  echo "Usage: Source Path is required in position 1"
  exit 1
else
  SRCFILEPATH=$1
  echo "Source path: $SRCFILEPATH"
fi
# Check to see if the file name pattern is given
if [ -z "$2" ]
then
  echo "Usage: File Name Pattern is required in position 2"
  exit 1
else
  FILENAMEPAT=$2
  echo "File Name Pattern: $FILENAMEPAT"
fi
#Moving to src directory
cd $SRCFILEPATH
pwd

FILECOUNT=`ls "$FILENAMEPAT"*|wc -l`
echo "$FILECOUNT"

if [ "$FILECOUNT" -ge 1 ]
then
    for file in "$FILENAMEPAT"*;
    do
      RECCOUNT=`cat ${file}| wc -l`
      echo "$RECCOUNT"
      if [ "$RECCOUNT" -gt 1 ]
      then
	  #!/bin/sh
      user="GLOBALDATA"
      pass="duVuqi50"
	  Search_Term = $(cut -d'|' -f1 ${file}|sed 1d)
      sqlplus -S $user/$pass <<EOF
      DELETE FROM SEARCH_TERM WHERE SEARCH_TERM_TX=$Search_Term;
      exit;
      EOF
      else
      echo "file has no records to process"
      fi
	done
else
    echo "No files exists with pattern "$FILENAMEPAT" in the path to process"
    exit 1
fi
#End Of Script

: invalid optionte.sh: line 12: set: -
set: usage: set [--abefhkmnptuvxBCHP] [-o option-name] [arg ...]
'earch_Term_Delete.sh: line 38: syntax error near unexpected token `
'earch_Term_Delete.sh: line 38: `    for file in "$FILENAMEPAT"*;

+ [ -z "yourinputparm1" ]
+ SRCFILEPATH=yourinputparm1
+ echo "Source path: yourinputparm1"
Source path: yourinputparm1

#!/bin/sh
set -x
# Check to see if source file path is given
if [ -z "$1" ]
then
  echo "Usage: Source Path is required in position 1"
  exit 1
else
  SRCFILEPATH=$1
  echo "Source path: $SRCFILEPATH"
fi
# Check to see if the file name pattern is given
if [ -z "$2" ]
then
  echo "Usage: File Name Pattern is required in position 2"
  exit 1
else
  FILENAMEPAT=$2
  echo "File Name Pattern: $FILENAMEPAT"
fi
#Moving to src directory
cd $SRCFILEPATH
pwd
FILECOUNT=`ls *"$FILENAMEPAT"*|wc -l`
echo $FILECOUNT
   for file in "$FILENAMEPAT"*;
   do
   if [ "$FILECOUNT" -gt 1 ]
   then
   user="GLOBALDATA"
   pass="duVuqi50"
   ServiceName="xxxx"
   sqlplus -S $user/$pass@ServiceName <<_EOF_
      SELECT * FROM SEARCH_TERM ;
      exit;
      _EOF_
      else
      echo "file has no records to process"
      exit 1
      fi
   done
#End of Script

etluser@avocado1:/var/local/ei/etl/Scripts>sh test_2.sh var/local/ei/etl/Scripts Search_Term
+ '[' -z var/local/ei/etl/Scripts ']'
+ SRCFILEPATH=var/local/ei/etl/Scripts
+ echo 'Source path: var/local/ei/etl/Scripts'
Source path: var/local/ei/etl/Scripts
+ '[' -z Search_Term ']'
+ FILENAMEPAT=Search_Term
+ echo 'File Name Pattern: Search_Term'
File Name Pattern: Search_Term
+ cd var/local/ei/etl/Scripts
test_2.sh: line 32: cd: var/local/ei/etl/Scripts: No such file or directory
+ pwd
/var/local/ei/etl/Scripts
++ wc -l
++ ls Search_Term_Delete.sh Search_Term_Manual.txt
+ FILECOUNT=2
+ echo 2
2
test_2.sh: line 52: warning: here-document at line 43 delimited by end-of-file (wanted `_EOF_')
test_2.sh: line 53: syntax error: unexpected end of file