-639   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

Explanation

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 processed.

Programmer response

Review the delete rule of the referential constraint and the partition keys for the index. Do one of the following:
  • 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.
  • 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.

SQLSTATE

56027