While the following statements always run fine on all the 32bit DB2 (V7/V8) installations that we have, it keeps on failing on one DB2 V8 FP4 Server that is installed in 64 bit mode:
CREATE TABLE Test
(P1 INT NOT NULL CONTRAINT TEST_P_1 PRIMARY KEY,
C1 INT NOT NULL,
V1 VARCHAR(100))
CREATE UNIQUE INDEX TEST_U_1 ON TEST (C1)
The error message was SQL0270N Function not supported (Reason code = "1"
. SQLSTATE=42997
If I change the CREATE UNIQUE INDEX to CREATE INDEX, then it would be fine. It seems the 64 bit DB2 Server only allows one unique index (whether primary or not) per table.
Has anybody experienced this restriction?
Regards, Nancy
CREATE TABLE Test
(P1 INT NOT NULL CONTRAINT TEST_P_1 PRIMARY KEY,
C1 INT NOT NULL,
V1 VARCHAR(100))
CREATE UNIQUE INDEX TEST_U_1 ON TEST (C1)
The error message was SQL0270N Function not supported (Reason code = "1"
. SQLSTATE=42997If I change the CREATE UNIQUE INDEX to CREATE INDEX, then it would be fine. It seems the 64 bit DB2 Server only allows one unique index (whether primary or not) per table.
Has anybody experienced this restriction?
Regards, Nancy