KFAA30613-E
A column cannot be added to a table(reason = aa....aa). (M+J+O)
The ALTER TABLE statement cannot be used to add columns to the following types of tables: <SQLSTATE: 53021>
-
A FIX table to which segments for storing rows are assigned
-
A base table for which BRANCH ALL is specified in the CREATE TABLE statement, and to which segments for storing rows are assigned
- aa....aa: Reason why columns cannot be added
-
-
A fix table in which data was stored at least once: A FIX table to which segments for storing rows are assigned
-
A table in which data has been stored at least once and for which BRANCH ALL option is specified: A base table for which BRANCH ALL is specified in the CREATE TABLE statement, and to which segments for storing rows are assigned
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
For details about how to add columns to these tables, see When a column cannot be added to a base table in the HADB Setup and Operation Guide.