读书人

关于建立PK报提示信息 SQL0598W,该如何

发布时间: 2012-03-06 20:47:55 作者: rapoo

关于建立PK报提示信息 SQL0598W
遇到这样一组语句 建表 建索引 建主键 ,在建立主键的时候提示SQL0598W
虽然PK是建立上了,但是,如何才能不让这个信息出现呢
建表:
CREATE TABLE SVR_INFO (
"SVR_ID " INTEGER NOT NULL ,
"SVR_IP " VARCHAR(15) NOT NULL ,
"SVR_NAME " VARCHAR(40) NOT NULL ,
"PORT_NO " INTEGER NOT NULL ,
"USER_NAME " VARCHAR(15) NOT NULL ,
"PWD " VARCHAR(32) NOT NULL ,
"REMARK " VARCHAR(20) )
IN "USERSPACE1 " INDEX IN "USERSPACE1 " ;
建索引:

CREATE UNIQUE INDEX SVR_INDEX1 ON SVR_INFO
( "SVR_ID " ASC)
INCLUDE ( "PWD " ASC,
"USER_NAME " ASC,
"PORT_NO " ASC,
"SVR_IP " ASC) ALLOW REVERSE SCANS;

建主键:
ALTER TABLE SVR_INFO
ADD PRIMARY KEY
( "SVR_ID ");


[解决办法]
CREATE TABLE SVR_INFO ( "SVR_ID" INTEGER NOT NULL , "SVR_IP" VARCHAR(15) NOT NULL , "SVR_NAME" VARCHAR(40) NOT NULL , "PORT_NO" INTEGER NOT NULL , "USER_NAME" VARCHAR(15) NOT NULL , "PWD" VARCHAR(32) NOT NULL , "REMARK" VARCHAR(20),PRIMARY KEY (SVR_ID) ) ;

将建立主键放到CREATE TABLE 的命令里面.

读书人网 >IBM DB2

热点推荐