Hitachi

Hitachi Advanced Database Messages


KFAA30630-E

A column for which NOT NULL constraint is specified cannot be added to a table in which data has been stored at least once. (M+J+O)

A column with the NOT NULL constraint specified cannot be added to a base table to which segments for storing rows are assigned. <SQLSTATE: 42IAC>

S:

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

Action:

For details about how to add columns to such tables, see When a column cannot be added to a base table in the HADB Setup and Operation Guide.