DB2 用Quest central 导入导出表中的数据

打开quest central 点击tools菜单下的sql editor执行下面的命令；

DB2 用Quest central 导入超出表中的数据所用的命令是：

导出：export to D:\zhpp3data\T_RP_MARKET_PRICE_WARNING.ixf of ixf select * from "ZHPP3"."T_RP_MARKET_PRICE_WARNING";
导入：import from D:\zhpp3data\T_RP_MARKET_PRICE_WARNING.ixf of ixf insert into "ZHPP3"."T_RP_MARKET_PRICE_WARNING";

其中黄色的部分，就是文件名和数据库名是根据自己的数据库信息和需要来写的。

如只想导入导入表中的个别列，可用以下方式：

export to D:\zhpp3data\T_DIM_SYS_CFG_1202_02.ixf of ixf select "CONFIG_KEY", "CONFIG_VALUE", "DESCRIPTION" from "ZHPP3"."T_DIM_SYS_CFG";

import from D:\zhpp3data\T_DIM_SYS_CFG_1202_02.ixf of ixf insert into "ZHPP3"."T_DIM_SYS_CFG" ("CONFIG_KEY", "CONFIG_VALUE", "DESCRIPTION");