SQLCODE -625 while creating a new primary key.

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
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 »

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.
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”