KFAA30609-E

The following operations cannot be performed for a FIX table: <SQLSTATE: 42I14>

• Define a column of the variable-length data type.

• Specify the chunk-archive specification.

• Define a table as a column store table.

aa....aa: Cause of the error

• define variable length column: Definition of a column of the variable-length data type

• specify the "ARCHIVABLE" option: Chunk-archive specification

• specify the "STORAGE FORMAT COLUMN" option: Definition of a column store table (COLUMN is specified for the STORAGE FORMAT option.)

S:

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

Action:

Check and, if necessary, revise the CREATE TABLE or ALTER TABLE statement.

• When defining a FIX table, do not define or specify any of the following:

  • Define a column of the variable-length data type.

  • Chunk-archive specification

  • Define a column store table (Specify COLUMN for the STORAGE FORMAT option).

• If any of the following conditions applies, cancel the FIX specification.

  • When defining a column of the variable-length data type

  • When specifying a chunk-archive

  • When defining a column store table (When specifying COLUMN for the STORAGE FORMAT option)