KFAA31553-E
The ARCHIVABLE clause cannot be specified for a table that is not a multi-chunk table in ALTER TABLE. (M+J+O)
The chunk-archive specification in the ALTER TABLE statement cannot be specified for a single-chunk table. <SQLSTATE: 42IBD>
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
A single-chunk table cannot be changed to an archivable multi-chunk table by using the ALTER TABLE statement. To change a single-chunk table to an archivable multi-chunk table, see Changing a single-chunk table to a multi-chunk table in the HADB Setup and Operation Guide.