Hitachi

Hitachi Advanced Database Messages


KFAA30743-E

The structure of foreign key "aa....aa"."bb....bb" is different from that of the primary key of "cc....cc"."dd....dd". (M+J+O)

The structure of a foreign key is different from the structure of the primary key that the foreign key references. <SQLSTATE: 42I54>

aa....aa:

Foreign key schema name

bb....bb:

Foreign key constraint name

cc....cc:

Schema name of the table for which the primary key is defined

dd....dd:

Identifier of the table in which the primary key is defined

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Check the structure (the following items) of the foreign key and of the primary key that the foreign key references, and then correct the SQL statement.

  • Number of columns

  • Data type of each column

  • Data length of each column