DB2 SQL-Error: -639
SQLState: 56027
Short Description: A NULLABLE COLUMN OF A FOREIGN KEY WITH A DELETE RULE OF SET NULL CANNOT BE A COLUMN OF THE KEY OF A PARTITIONED INDEX
A partition key of the clustering index cannot be updated. Therefore, a foreign key column with a delete rule of SET NULL cannot be a column of a partition key if that column is nullable. If this error occurs for an ALTER TABLE operation, the foreign key cannot be created. If this error occurs for a CREATE INDEX operation, the index cannot be created. System action: The statement cannot be executed. Programmer response: Review the delete rule of the referential constraint and the partition keys for the index. Do one of the following: v If the operation in error was CREATE INDEX, either change the index partition key definition or drop and redefine the referential constraint with a different delete rule. v If the operation in error was ALTER TABLE, change the referential delete rule so that all nullable index keys are not part of the foreign keys.