-613

THE PRIMARY KEY OR A UNIQUE CONSTRAINT IS TOO LONG OR HAS TOO MANY COLUMNS

Explanation

The number of columns that are defined for a PRIMARY KEY or UNIQUE constraint is greater than 64, or the sum of the column length attributes is greater than the number allowed for the type of index.

If the failing statement was an ALTER TABLE statement that included the SET DATA TYPE clause to alter the definition of an existing column, a column being changed is part of a unique or primary constraint. The new sum of the lengths of the columns of the keys exceeds 255-n, where n is the number of columns allowing null values. This sum currently exceeds the maximum number that is allowed.

If the failing statement was an ALTER TABLE statement with a PARTITIONING KEY specification, only 64 columns can be specified, and the combined lengths of all columns specified in the PARTITIONING KEY clause exceeds the maximum length of 255-n, where n is the number of columns that can contain null values.

System action

The statement cannot be processed.

Programmer response

Change the table definition to keep within the prescribed limits.

SQLSTATE

54008


---

테이블 설계 변경...

---

출처 : http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2z9.doc.codes/src/tpc/n613.htm

Posted by pwsunf
,