-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