-625 TABLE `table-name` DOES NOT HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE PRIMARY OR UNIQUE KEY

Explanation
 The ALTER TABLE statement is invalid for one of
the following reasons:
 The table does not have a unique index with a key that is identical
to the nominated primary or unique key.
A unique index exists, but the index is already being used to
enforce referential constraints. In this case, DB2® does not choose the index to enforce the
primary or unique key.

System action
 The statement cannot be processed.

Programmer response
 Make sure the key list specified on the
ALTER TABLE statement identifies an existing unique index of the table
that is not already enforcing referential constraints.

SQLSTATE
 55014

-625 TABLE table-name DOES NOT HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE PRIMARY OR UNIQUE KEY

Explanation

System action

Programmer response

SQLSTATE

-625 TABLE `table-name` DOES NOT HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE PRIMARY OR UNIQUE KEY