db2 "export to employee.del of del messages emp.msg select * from employee "

db2 "export to employee_2.del of del modified by Chardel'' messages emp_2.msg select * from employee"

db2 "export to employee_3.ixf of ixf messages emp_3.msg select * from employee"

db2 "export to emp_resume.del of del lobs to /data/lobs modified by lobsinfile select * from emp_resume"

db2 "export to emp_resume_2.del of del lobs to /data/lobs2 modified by lobsinsepfiles select * from emp_resume"

db2 "import from order.txt of del allow write access commitcount 10 insert into vps.order"

db2 "export to s1.t1.ixf of ixf messages s1.t1.msg select * from s1.t1"

db2 "import from s1.t1.ixf of ixf insert into s1.t1"

ITPub博客

DB2 export 与 import 相关操作

最新文章