I have been facing SQLCODE=-625 while I try to create a new primary key for a table. I have dropped the existing primary key and creating a new one. With this, I get the SQL CODE of -625 and the following error message comes:
Is it mandotary to define a Unique Index on the table before we have the new primary key ? Please help me on this.
Code: Select all
SQLCODE = -625, ERROR: TABLE Tablename DOES NOT HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE PRIMARY OR UNIQUE KEY