关于DB2创建表报错

Question

[code="sql"]
CREATE TABLE XTCUR."DOMAINDICT" (
"ID" BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (

START WITH +1

INCREMENT BY +1

MINVALUE +1

MAXVALUE +9223372036854775807

NO CYCLE

CACHE 20

NO ORDER ) ,
"STRTYPE" VARCHAR(32) NOT NULL ,
"STRNAME" VARCHAR(64) NOT NULL ,
"STRVALUE" VARCHAR(256) NOT NULL )

IN "CUR_DAT" INDEX IN "CUR_IDX" ;
ALTER TABLE XTCUR."DOMAINDICT" APPEND ON;
[/code]

这里我不知道IN "CUR_DAT" INDEX IN "CUR_IDX" ;是什么意思
创建的时候报错
[color=red]
Statement processed with ERROR
[DB2/NT] SQL0204N "CUR_DAT" 是一个未定义的名称。SQLDATE=42704
*** Execution stopped due to error ***
[/color]

Answer 1

"CUR_DAT"和"CUR_IDX"是表空间(table space),
意思是在CUR_DAT表空间创建表DOMAINDICT，并在表空间CUR_IDX中建立索引，
表空间可以通过create TABLESPACE 语句创建