#!/bin/sh
cd ${HOME}source .bash_profile
cd ${QCUBIC_DATA}/trc
sed -n '/^\[EXEC_DDL_BEGIN/,/SUCCESS\]/p' qcubic_qp.log |grep -v '\[2022'| awk -F ":" '{print $NF}'|sed 's/\]/;/g'|grep -v "\[Thread-"|grep -v "SUCCESS;" > ddl.sql
qs -s 192.168.1.24 -port 22345 -u sys -p manager -f ddl.sql