我在PDM中先执行change current DBMS设为ORACLE,然后用connect database(odbc for oracle)联接database ,执行generate database生成数据库,
create table "anhuan_kp_aqjl" ( "idt" INTEGER not null, "id" CHAR(6) not null, "rs__quyubianma" CHAR(10) not null, "rs__id" CHAR(10) not null, "shijian" DATE, "jianyao" LONG, "shjl" CHAR(30), "quyubianma" CHAR(10), constraint PK_ANHUAN_KP_AQJL primary key ("idt", "id") ) / comment on table "anhuan_kp_aqjl" is '安全奖励' / comment on column "anhuan_kp_aqjl"."idt" is '序号' / comment on column "anhuan_kp_aqjl"."id" is '员工编号' / comment on column "anhuan_kp_aqjl"."rs__quyubianma" is '区域编码' / comment on column "anhuan_kp_aqjl"."rs__id" is '员工编号' / comment on column "anhuan_kp_aqjl"."shijian" is '时间' / comment on column "anhuan_kp_aqjl"."jianyao" is '简要事迹' / comment on column "anhuan_kp_aqjl"."shjl" is '奖励类别' / comment on column "anhuan_kp_aqjl"."quyubianma" is '区域编码' /
"idt" INTEGER not null,
"id" CHAR(6) not null,
"rs__quyubianma" CHAR(10) not null,
"rs__id" CHAR(10) not null,
"shijian" DATE,
"jianyao" LONG,
"shjl" CHAR(30),
"quyubianma" CHAR(10),
constraint PK_ANHUAN_KP_AQJL primary key ("idt", "id")
)
/
comment on table "anhuan_kp_aqjl" is
'安全奖励'
/
comment on column "anhuan_kp_aqjl"."idt" is
'序号'
/
comment on column "anhuan_kp_aqjl"."id" is
'员工编号'
/
comment on column "anhuan_kp_aqjl"."rs__quyubianma" is
'区域编码'
/
comment on column "anhuan_kp_aqjl"."rs__id" is
'员工编号'
/
comment on column "anhuan_kp_aqjl"."shijian" is
'时间'
/
comment on column "anhuan_kp_aqjl"."jianyao" is
'简要事迹'
/
comment on column "anhuan_kp_aqjl"."shjl" is
'奖励类别'
/
comment on column "anhuan_kp_aqjl"."quyubianma" is
'区域编码'
/
pd得pdm上有个设置