DB2 export 與 import 相關操作

fjzcau發表於2015-03-28
原文網址 : http://blog.itpub.net/22661144/viewspace-1477204/
DB2ExportImport

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部落格 ” ，連結：http://blog.itpub.net/22661144/viewspace-1477204/，如需轉載，請註明出處，否則將追究法律責任。

相關文章