UNIX for Beginners Questions & Answers

switch_file
switch_file
billing_file
billing_file

for i in $(ls /tmp*.switch) ; 
do
  sed -i "s|FILENAME|$i|g" /tmp/data1.ctl  --Read
  sqlldr TNS control=/tmp/data1.ctl
  sed -i "s|i|FILENAME|g" /tmp/data1.ctl
done

for i in $(ls /tmp*.billing) ; 
do
  sed -i "s|FILENAME|$i|g" /tmp/data1.ctl  --Read
  sqlldr TNS control=/tmp/data1.ctl
  sed -i "s|i|FILENAME|g" /tmp/data1.ctl
done

load data 
infile 'FILENAME' "str '\r\n'"
append
into table TEXT
fields terminated by ' '
trailing nullcols

for table in switch billing
do
   for file in /tmp/*.$table 
   do
       if [ -f "$file" ] 
       then
           sed -e "s|FILENAME|$i|g" -e "s|TEXT|$table|g" /tmp/data1.ctl  > /tmp/$$_data1.ctl
           sqlldr TNS control=/tmp/$$_data1.ctl
           rm /tmp/$$_data1.ctl
       fi
    done
done