#!/bin/bash

echo "APPLY SQL TO SERVER"

echo "CONNECT TO MWCONFIG; " >$2/migrate.sql
# echo "BEGIN TRANSACTION;">>$2/migrate.sql
cat $2/$4 >>$2/migrate.sql
echo -e "\n\nTERMINATE;" >>$2/migrate.sql

cd $2/../..

docker compose exec mwconfig bash -c "su - \$DB2INSTANCE -c 'db2 -tvf /var/cicd/migrate.sql'"