DB2导入导出方法总结

export to D:\T_TESTTABLE20121220.del of del 
select * from T_TESTTABLE@ 

import from d:\T_TESTTABLE20121220.del of del 
insert into T_TESTTABLE@ 

import from d:\T_TESTTABLE20121220.ixf of ixf 
insert into T_TESTTABLE@ 

import from d:\T_TESTTABLE20121220.del of del 
replace into T_TESTTABLE@ 
import from d:\T_TESTTABLE20121220.ixf of ixf 
replace into T_TESTTABLE@ 

import from D:\T_TESTTABLE20121220.ixf of ixf 
create into T_TESTTABLE@ 

LOAD CLIENT FROM D:\T_TESTTABLE20121220.IXF OF IXF 
INSERT INTO T_TESTTABLE@ 
LOAD CLIENT FROM D:\T_TESTTABLE20121220.del OF del 
INSERT INTO T_TESTTABLE@

LOAD CLIENT FROM D:\T_TESTTABLE20121220.IXF OF IXF 
MODIFIED BY IDENTITYOVERRIDE INSERT INTO T_TESTTABLE@ 

LOAD CLIENT FROM D:\T_TESTTABLE20121220.del OF del 
modified by codepage=1386 INSERT INTO T_TESTTABLE@ 

LOAD CLIENT FROM C:\空文件.TXT OF DEL 
TERMINATE INTO T_TESTTABLE@