KFAA30742-E
A foreign key "aa....aa"."bb....bb" cannot be defined because the referenced table "cc....cc"."dd....dd" does not have a primary key. (M+J+O)
A foreign key cannot be defined because no primary key has been defined for the referenced table. <SQLSTATE: 42I53>
- aa....aa:
-
Foreign key schema name
- bb....bb:
-
Foreign key constraint name
- cc....cc:
-
Referenced table schema name
- dd....dd:
-
Table identifier of referenced table
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Correct the SQL statement so that a table that has a primary key defined is specified as the referenced table.