DB2 用到的基本SQL语句

导出某个数据库中的USER表的数据：

EXPORT TO "E:\DATE\USER.ixf" OF IXF MESSAGES "E:\DATE\USER.out" SELECT * FROM DB2ADMIN.USER

导入到某个库中USER表的数据：（首先创建同样的一张USER表，然后进行导入）

IMPORT FROM "E:\DATE\USER.ixf" OF IXF MODIFIED BY IDENTITYIGNORE MESSAGES "E:\DATE\USER.out" INSERT INTO DB2ADMIN.USER;

 

 

 

 

CREATE TABLE "DB2ADMIN".T_CONTRAST_ZL_TO_NEUSOFT (
  ZLTONEUID INTEGERNOT NULL,
  ZLJGBM VARCHAR(25),
  ZLJGMC VARCHAR(25),
  DRJGBM VARCHAR(25),
  DRJGMC VARCHAR(25),
  DBPP VARCHAR(1),
FJJGBM VARCHAR(25),
FJJGMC VARCHAR(25)
) 
  IN "USERSPACE1"
  INDEX IN "USERSPACE1";


ALTER TABLE "DB2ADMIN".T_CONTRAST_ZL_TO_NEUSOFT
  DATA CAPTURE NONE
  PCTFREE 0
  LOCKSIZE ROW
  APPEND OFF
  NOT VOLATILE;


COMMENT ON TABLE "DB2ADMIN".T_CONTRAST_ZL_TO_NEUSOFT IS '中联与东软机构对比表';


COMMENT ON "DB2ADMIN".T_CONTRAST_ZL_TO_NEUSOFT ( 
ZLTONEUID IS '对比表主键',
ZLJGBM IS 'A机构代码',
ZLJGMC IS 'A机构名称',
DRJGBM IS 'B机构编码',
DRJGMC IS 'B机构名称',
DBPP IS '对比匹配（Ｙ完全匹配，ＺA存在，ＤB存在）',
FJJGBM IS '父级机构编码',
FJJGMC IS '父级机构名称');


alter table T_CONTRAST_ZL_TO_NEUSOFT add   primary   key(ZLTONEUID);
COMMIT;


insert into T_CONTRAST_ZL_TO_NEUSOFT values(2,'ZL_002','A机构名称_2','DR_002','B机构名称_2','Y','FJ_02','父级机构名称_2');


--更改表结构：
alter table T_CONTRAST_ZL_TO_NEUSOFT add FJJGBM VARCHAR(25);
alter table T_CONTRAST_ZL_TO_NEUSOFT  add FJJGMC VARCHAR(25);