总是提示说“是未定义的名称”。。。
同一个脚本里的建表sql,建完显示成功,用控制中心去看,表也有了。
但在db2cmd 那用建表的那个用户webuser connect 进去
select * from WFFARUT就可以;
但select * from Address 就提示:WEBUSER.ADDRESS" 是未定义的名称。 SQLSTATE=42704
郁闷,建表的脚本如下:
connect to edw user WEBUSER using web;
drop table "WFFARUT";
drop table "ADDRESS";
CREATE TABLE "WEBUSER "."WFFARUT" (
"CHECK_IND" CHAR(1) NOT NULL ,
"TRAN_TELLER" CHAR(4) ,
"TRAN_DEPT" SMALLINT ,
"TRAN_DATE" DATE ,
"TRAN_TIME" TIME ,
"AUTH_TELLER" CHAR(4) ,
"AUTH_DATE" DATE ,
"AUTH_TIME" TIME ,
"RECORD_NO" SMALLINT NOT NULL ,
"MAIN_AREA_NO" CHAR(4) NOT NULL ,
"AREA_TYPE" CHAR(2) ,
"SUB_DEPT_NO" CHAR(4) ) ;
ALTER TABLE "WEBUSER "."WFFARUT"
ADD CONSTRAINT "PK_WFFARUT" PRIMARY KEY
("CHECK_IND",
"MAIN_AREA_NO",
"RECORD_NO");
create table "WEBUSER". "Address"
(
"id" NUMERIC(6,0) not null generated by default as identity,
"officerCode" CHAR(4),
"company" varchar(40),
"name" varchar(20),
"phone1" VARCHAR(20),
"phone2" VARCHAR(20),
"fax" VARCHAR(20),
"address" VARCHAR(100),
"email" VARCHAR(40),
constraint P_PK_ADDR primary key ("id")
);