/tsmmon/ITM/bin# ./CandleExecute cq "runscript.sh migrate-export"
KFWWORKSPACELINK APPLICATIONTAG DELETE FROM KFWWORKSPACELINK WHERE APPLICATIONTAG='K25';
KFWWORKSPACE WSGROUPID DELETE FROM KFWWORKSPACE WHERE WSGROUPID LIKE 'zk25%';
KFWPRESENTATION OBJECTID DELETE FROM KFWPRESENTATION WHERE OBJECTID = 'k25';
KFWPRESDEF PRESENTATIONID DELETE FROM KFWPRESDEF WHERE PRESENTATIONID ='WORKSPACE~REPORT~zk25.DC_obj_status'; THERE NEEDS TO BE A DELETE STATEMENT FOR EACH ONE
KFWFOUNDODI APPL DELETE FROM KFWFOUNDODI WHERE APPL='K25';
KFWPARMA TABLENAME DELETE FROM KFWPARMA WHERE TABLENAME LIKE 'K25%';
KFWEDGE CHILD DELETE FROM KFWEDGE WHERE CHILD LIKE '%zk25';
KFWMOBJASSIGNED ID DELETE FROM KFWMOBJASSIGNED WHERE ID LIKE '%zk25%';
KFWMOBJPROP ID DELETE FROM KFWMOBJPROP WHERE ID LIKE '%zk25%';
KFWMOBJ TEMPLATE DELETE FROM KFWMOBJ WHERE TEMPLATE LIKE 'zk25%';
KFWTMPLSIT TEMPLATE DELETE FROM KFWTMPLSIT WHERE TEMPLATE LIKE 'zk03%';
KFWTMPLSTA TEMPLATE DELETE FROM KFWTMPLSTA WHERE TEMPLATE LIKE 'zk25%';
KFWTMPL NAME DELETE FROM KFWTMPL WHERE NAME LIKE 'zk25%';
KFWSEEDLEVEL FILENAME DELETE FROM KFWSEEDLEVEL WHERE FILENAME='k25%';
KFWQUERY APPL DELETE FROM KFWQUERY WHERE APPL='K25';
db2 "DELETE FROM KFWWORKSPACELINK WHERE APPLICATIONTAG='K11'"
db2 "DELETE FROM KFWWORKSPACE WHERE WSGROUPID LIKE 'zk11.avail%'"
db2 "DELETE FROM KFWPRESENTATION WHERE OBJECTID = 'k11'"
db2 "DELETE FROM KFWPRESDEF WHERE PRESENTATIONID ='WORKSPACE~REPORT~zk11.DC_obj_status'"
db2 "DELETE FROM KFWFOUNDODI WHERE APPL='K11'"
db2 "DELETE FROM KFWPARMA WHERE TABLENAME LIKE 'K11.avail%'"
db2 "DELETE FROM KFWEDGE WHERE CHILD LIKE '%zk11'"
db2 "DELETE FROM KFWMOBJASSIGNED WHERE ID LIKE '%zk11.avail%'"
db2 "DELETE FROM KFWMOBJPROP WHERE ID LIKE '%zk11.avail%'"
db2 "DELETE FROM KFWMOBJ WHERE TEMPLATE LIKE 'zk11.avail%'"
db2 "DELETE FROM KFWTMPLSIT WHERE TEMPLATE LIKE 'zk11%'"
db2 "DELETE FROM KFWTMPLSTA WHERE TEMPLATE LIKE 'zk11.avail%'"
db2 "DELETE FROM KFWTMPL WHERE NAME LIKE 'zk11.avail%'"
db2 "DELETE FROM KFWSEEDLEVEL WHERE FILENAME='k11.avail%'"
db2 "DELETE FROM KFWQUERY WHERE APPL='K11.avail'"