- #!/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'"
|
