Hitachi

Hitachi Advanced Database Messages


KFAA31657-E

A primary key cannot be defined.(reason = "aa....aa") (M+J+O)

If the chunk specification is specified, a primary key cannot be defined. Conversely, if a primary key is defined, the chunk specification cannot be specified. <SQLSTATE: 42IAF>

aa....aa: Cause of the error
  • the table is a multi-chunk table: The base table for which a primary key will be defined also contains the chunk specification.

S:

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

Action:

The chunk specification and a primary key cannot be defined together. Review the database design.