【文件属性】：
文件名称：DB2数据库教程
文件大小：12.31MB
文件格式：PDF
更新时间：2020-10-12 10:40:11
DB2
启动DB2服务：db2start
关闭DB2服务: db2stop
一、加载数据：
1、 以默认分隔符加载,默认为“,”号
db2 "import from btpoper.txt of del insert into btpoper"
2、 以指定分隔符“|”加载
db2 "import from btpoper.txt of del modified by coldel| insert into btpoper"
import from import.txt of del modified by coldel | insert into ts_tcqs_rhjgb
import from import.txt of del modified by coldel: insert into ts_tcqs_rhjgb
二、卸载数据：
1、 卸载一个表中全部数据
db2 "export to btpoper.txt of del select * from btpoper"
db2 "export to btpoper.txt of del modified by coldel| select * from btpoper"
export to export2.txt of del modified by coldel: select * from ts_tcqs_xtztb