SQLCODE -625 while creating a new primary key.

RDBMS from IBM.
Previous topicNext topic

Topic Author
Sulabh Sinha
Registered Member
Posts: 17
Joined: Tue Aug 20, 2013 10:44 am

SQLCODE -625 while creating a new primary key.

Post by Sulabh Sinha » Sat Jul 16, 2016 2:42 pm

Hi,

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:

Code: Select all

SQLCODE = -625, ERROR:  TABLE Tablename DOES NOT HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE PRIMARY OR UNIQUE KEY
Is it mandotary to define a Unique Index on the table before we have the new primary key ? Please help me on this.



Previous topicNext topic

Return to “IBM DB2.”