Shell Programming and Scripting

full()
{
echo "You entered full $1,$2,$3"
db2 "call util.DATA_REFRESH('LOAD','$1','$2','$3','$2','R','?',?)"  
rc=$?
if [ "$rc" -ne 0 ] ;then
echo "$1.$2" >>failure_list.txt
else 
echo "$1.$2" >>Success_list.txt
fi
}
schema=schema
table=table
nickname=nickname
 
split -l 4 full_refresh.txt
rc=$?
if [ "$rc" -ne 0 ] ;then
mutt -s "Unable to split" $mail_list
exit; 
fi
ls xa*  > list.txt
rc=$?
if [ "$rc" -ne 0 ] ;then
mutt -s "Unable to gather splitted file names" $mail_list 
exit;
fi
 
while read list
do
read_line=0
 
while read line1
do
read_line=`expr $read_line + 1`
echo $line1
eval "$schema""$read_line"=`echo $line1|awk 'BEGIN { FS = "|" } ; {print $1}'`
eval "$table""$read_line"=`echo $line1|awk 'BEGIN { FS = "|" } ; {print $2}'`
eval "$nickname""$read_line"=`echo $line1|awk 'BEGIN { FS = "|" } ; {print $3}'`
export "$schema""$read_line"
export "$table""$read_line"
export "$nickname""$read_line"
 
done < list
 
full $schema1 $table1 $nickname1 & full $schema2 $table2 $nickname2 & full $schema3 $table3 $nickname3 & full $schema4 $table4 $nickname4

#!/bin/sh
file='full_refresh.txt'
schema=schema
table=table
nickname=nickname

# i don't have this function...test
db2() {
        echo "db2: $@"
        #pretend like it takes some time
        sleep 10
}

full() {
        echo "You entered full $1,$2,$3"
        if db2 "call util.DATA_REFRESH('LOAD','$1','$2','$3','$2','R','?',?)"; then
                echo "$1.$2" >>Success_list.txt
        else
                echo "$1.$2" >>failure_list.txt
        fi
}

while IFS='|' read schema table nickname _; do
        count=$((count+1))
        full "$schema" "$table" "$nickname" &
        if [ "$count" -ge 4 ]; then
                wait
                count=0
        fi
done < "$file"