作者：_Terr1鄭x宜_F | 来源：互联网 | 2023-09-09 16:21
1.导出 DEL 文本文件
export to D:\T_TESTTABLE20121220.del of del
select * from [email&＃160;protected]
2.导出 ixf 文本文件.ixf 文件包含表结构和db2数据库信息
export to D:\T_TESTTABLE20121220.ixf of ixf
select * from [email&＃160;protected]
3.导入数据 之 数据插入
import from d:\T_TESTTABLE20121220.del of del
insert into [email&＃160;protected]
import from d:\T_TESTTABLE20121220.ixf of ixf
insert into [email&＃160;protected]
4.导入数据 之 数据替换
import from d:\T_TESTTABLE20121220.del of del
replace into [email&＃160;protected]
import from d:\T_TESTTABLE20121220.ixf of ixf
replace into [email&＃160;protected]
5.导入数据 之 创建表结构,并导入数据
import from D:\T_TESTTABLE20121220.ixf of ixf
create into [email&＃160;protected]
6.导入数据 之 load导入表数据
LOAD CLIENT FROM D:\T_TESTTABLE20121220.IXF OF IXF
INSERT INTO [email&＃160;protected]
LOAD CLIENT FROM D:\T_TESTTABLE20121220.del OF del
INSERT INTO [email&＃160;protected]
7.导入数据 之 包含ID为GENERATED ALWAYS 始终由系统生成的表
LOAD CLIENT FROM D:\T_TESTTABLE20121220.IXF OF IXF
MODIFIED BY IDENTITYOVERRIDE INSERT INTO [email&＃160;protected]
8.导入数据 之 DEL文件中文乱码的解决
LOAD CLIENT FROM D:\T_TESTTABLE20121220.del OF del
modified by codepage=1386 INSERT INTO [email&＃160;protected]
如果有中文乱码和identity 的话,codepage 写前面
9.导入数据 之 load表时,表锁死
LOAD CLIENT FROM C:\空文件.TXT OF DEL
TERMINATE INTO [email&＃160;protected]
京公网安备 11010802041100号