In this post, you’ll learn about the error message -539 table table name does not have a primary key in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-539 table table name does not have a primary key
Reason for the Error
The code is used to report that the indicated table, which is nominated as a parent in a FOREIGN KEY clause, cannot be defined as a parent because it does not have a primary key.
Solution
Correct the statement so that the table nominated as a parent in the FOREIGN KEY clause references a table with a primary key, or define a primary key for the table nominated as a parent.