DB2导入导出方法总结

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

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

 3.导入数据 之 数据插入 

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@ 

DB2导入导出方法总结

标签：create   sel   always   identity   generate   ace   表数   建表   generated