I have written a script to run on UNIX server. When I tested, it always hanged on after "date +"%D %T: XXXXXX script started." part. Then it wouldn't go further. UNIX server gave me one error message. I used the same code in another script. It works fine. I think the major problem may be in For...Loop part. The script can not access into the $filename. I post code and error message here. Please help me to figure out where the bottleneck is. Thanks a lot

# Started DB Job on xxx table.
for filename in directory_name/xxx_*.sql
do
sqlplus -s > temp.log 2>&1 dbuser/pswd@$ORACLE_SID @$filename
If [ $? = 0]
then date +"%D %T: $filename successully executed." >> xxxx.log
else date +"%D %T: Error executing $filename." >> xxxx.log
grep "ORA-" temp.log >> xxxx.log
date +"%D %T: Exiting script." >> xxxx.log
mail -s 'XXXX execution: Unsuccessful. See log file for errors.' mymail@company.com<xxxx.log
exit 1
fi
done

# Delete temp.log file
rm -f temp.log

mail -s " XXXX execution: Successful" mymail@company.com <xxxx.log

exit 0

You cannot capitalize keywords. You need to use "if", not "If". And the brackets must be surrounded by white space. You need a space bewteen the zero and the closing bracket.

Thanks for your advise. something was typo. Could you please point out the coding problem in the script. Do I need to declare a envirnment variable to point to that directory? Is there any problem in wildcard for file name?

Perderabo:

You are right. "If" caused the problem. Thanks for your help.