logo  
Google
 

DB2 SQL-Error: -613

SQLState: 54008

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

This error code results from a problem with the columns that are defined for a PRIMARY KEY or UNIQUE constraint. The number of columns 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 nulls. 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 CREATE or ALTER statement cannot be executed. The specified table cannot be created or altered. Programmer response: Change the table definition to keep within the prescribed limits.

 <-  BACK TO INDEX