#!/bin/bash

for FILE in `ls -1 /home/mwconfig/init/*.sql | sort -g`
do
    echo "CONNECT TO MWCONFIG~" > /tmp/migrate.sql
    cat $FILE >> /tmp/migrate.sql
    echo -e "\n\nTERMINATE~" >> /tmp/migrate.sql
    su - db2inst1 -c "db2 -td~ -qvf /tmp/migrate.sql"
done

TEMP=""

# for FILE in /home/mwconfig/storeprocedure/merge*.db2
for FILE in `ls -1 /home/mwconfig/storeprocedure/*.db2 | sort -g`
do
    TEMP+="echo $FILE;"
    TEMP+="db2 -td@ -f $FILE;"
done

TEMP=${TEMP%;}

su - db2inst1 -c "db2 connect to mwconfig > /dev/null 2>&1;
                  db2 set schema mwconfig > /dev/null 2>&1;
                  $TEMP; 
                  db2 terminate > /dev/null 2>&1;"

for FILE in `ls -1 /home/mwconfig/migration/*.sql | sort -g`
do
    echo "CONNECT TO MWCONFIG;" > /tmp/migrate.sql
    cat $FILE >> /tmp/migrate.sql
    echo -e "\n\nTERMINATE;" >> /tmp/migrate.sql
    su - db2inst1 -c "db2 -qtvf /tmp/migrate.sql"
done
touch /var/migrate.done