Shell Programming and Scripting

I have a directory that I would like to check for files of a certain pattern, that pattern being "gspp*". There may be several files or there may be no files that fit the given pattern at the time the script is run. In the event a file(s) is found, I would like to rename it to a temporary file, load this file into a database using sql loader and then move it into another directory when I'm done.

The process works perfectly when there is one or more files that match the pattern. When there are none, I run into a problem. When there are none, it still tries to do all of the other steps (renaming, loading, moving) on a filename that does not exist. I do not want this to occur.

Thanks.

OK, that's much clearER.
Couple of notes:

The sqlldr command is fine. Yes, I am moving it prior to calling sqlldr. I am renaming it from a filename that varies day-to-day to a static temporary one. Then my control file references that static temporary one in its body. After it is loaded, I rename the file to its old name and then archive it.

I'll remove that, but I still ask, how do I ensure it's not hitting the else block? Do I check if $FILES = null?

You don't need the if statement at all.

Code:

for FILES in gspp*
do
    echo "Loading $FILES" >> ../path/mylog.log
    mv $FILES temp.tmp
    sqlldr user/pass@DB control=/path/control.ctl
    bad=/path/bad.bad log=/path/log.log
    mv temp.tmp ../archive/$FILES
    echo "Load of $FILES complete!" >> ../path/mylog.log
    echo "Deleting remote $FILES" >> /path/mylog.log
    /path/delfile.sh $FILES
    ftp -nvi < delfile.ftp >> ../path/mylog.log
done

This didn't work. It's copying gspp* into $FILES and attempting to execute the rest of the commands.

Code:

for FILES in gspp*
do
echo "Loading $FILES" >> ../logs/myloglog
mv $FILES temp.tmp
...

do you have any of

1. "-f" at end of the #! line at the start of the script
2. set -x in the script
3. IFS=<something> in the script
4. set -o noglob in the script
?

none of that