db2 清表脚本

来源:互联网 发布:代码高亮js 编辑:程序博客网 时间:2024/04/28 12:16

db2直接用空文件replace表,没有日志且


db2 connect to masdb user mas using mas >> clearData.log



db2 import from /dev/null of del replace into T1>> clearData.log;
db2 import from /dev/null of del replace into T3>> clearData.log;

db2 import from /dev/null of del replace into T3>> clearData.log;

db2 import from /dev/null of del replace into T4>> clearData.log;


db2 disconnect masdb

原创粉丝点击