db2数据库表的导入导出数据库表
导出表结构，命令行如下：db2look -d dbname -e -a -x -i username -w password -o 123.sql
导出表中数据
export to of ixf select [字段(例: * or col1,col2,col3)] from TABLE1;
export to of del select [字段(例: * or col1,col2,col3)] from TABLE1;
导入表的数据
import from of ixf insert into TABLE1;
load from of ixf insert into TABLE1;
load from of ixf replace into TABLE1; // 装入数据前，先删除已存在记录
load from of ixf restart into TABLE1; // 当装入失败时，重新执行，并记录导出结果和错误信息
页:
[1]