SQL CODE -625 while creating primary key
SQL CODE -625 while creating primary key
I was trying to create a new primary key on a table by dropping the existing primary key.  I got the sql code of  -625, when I tried to create the new primary key and the error message read as
SQLCODE = -625, ERROR: Â TABLE Tablename DOES NOT HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE PRIMARY ORÂ UNIQUE KEY
Do I need to define a Unique index on the table for the new primary key ?
“; ; ; ;