logo  
Google
 

DB2 SQL-Error: -625

SQLState: 55014

Short Description: TABLE DOES NOT HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE PRIMARY OR UNIQUE KEY

The ALTER TABLE statement is invalid for one of the following reasons: v The table does not have a unique index with a key that is identical to the nominated primary or unique key. v 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 executed. 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.

 <-  BACK TO INDEX