-539 TABLE table-name DOES NOT HAVE A PRIMARY KEY
Explanation
DB2® cannot perform the CREATE or ALTER TABLE statement because the indicated table does not have a primary key. Thus, the primary key cannot be dropped, or the table cannot be defined as a parent in a referential constraint.
System action
The statement cannot be processed.
Programmer response
Correct the statement to reference a table with a primary key, or define a primary key with ALTER TABLE ADD PRIMARY KEY before referencing the table in a FOREIGN KEY clause.
SQLSTATE
42888