db2数据库表的导入导出数据库表

导出表结构，命令行如下：

[color=red]db2look -d dbname -e -a -x -i username -w password -o 123.sql [/color]


导出表中数据

[color=red]
export to [path(例:D:\TABLE1.ixf)] of ixf select [字段(例: * or col1,col2,col3)] from TABLE1;


export to [path(例:D:\TABLE1.del)] of del select [字段(例: * or col1,col2,col3)] from TABLE1;[/color]


导入表的数据


[color=red]import from [path(例:D:\TABLE1.ixf)] of ixf insert into TABLE1;


load from [path(例:D:\TABLE1.ixf)] of ixf insert into TABLE1;


load from [path(例:D:\TABLE1.ixf)] of ixf replace into TABLE1;[/color] // 装入数据前，先删除已存在记录


[color=red]load from [path(例:D:\TABLE1.ixf)] of ixf restart into TABLE1;[/color] // 当装入失败时，重新执行，并记录导出结果和错误信息