#!/bin/ksh
# USAGE: Script is used to generate a file to add spool to all files.
# check for filenames for spaces:
x=$(find . -type f -name "* *" |wc -l)
if [ $x != 0 ]; then
echo $x
j=$(find . -type f -name "* *")
echo -e "Correct the filenames with spaces: \n$j "
exit;
fi
touch run_all_scripts.sql
echo "set echo on" >>run_all_scripts.sql
echo "set serveroutput on size unlimited" >>run_all_scripts.sql
for i in `ls *.sql | grep -v run_all_scripts.sql`
do
j=${i%.*}
echo spool ELS_GIL_$j"."log >>run_all_scripts.sql
echo "@$i" >>run_all_scripts.sql
echo "spool off" >>run_all_scripts.sql
echo "pause;" >>run_all_scripts.sql
echo " " >>run_all_scripts.sql
done
echo "set echo off" >>run_all_scripts.sql
echo $'\e[1;33m\e[4m' "Script executed fine- check the file to confirm" $'\e[0m'
