KFAA31685-E
aa....aa cannot be specified. (reason = bb....bb) (M+J+O)
aa....aa cannot be specified. <SQLSTATE: 42IAB>
- aa....aa: Invalid option
-
-
BRANCH: BRANCH specification
-
COMPRESSION TYPE: Compression-type specification
-
CHUNK ARCHIVABLE: Chunk-archive specification
-
- bb....bb: Reason it cannot be specified
-
-
A data type is not VARCHAR or VARBINARY
The data type of the column is not VARCHAR or VARBINARY
-
The table option BRANCH ALL is specified
The table option BRANCH ALL is specified.
-
The table option STORAGE FORMAT COLUMN is specified
COLUMN is specified for the table option STORAGE FORMAT.
-
The table option STORAGE FORMAT COLUMN is not specified
COLUMN is not specified for the table option STORAGE FORMAT.
-
The table option BRANCH ALL was specified when the table was defined
The table option BRANCH ALL was specified when the table was defined.
-
The table is a column store table
The table is a column store table.
-
The table is a row store table
The table is a row store table.
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Take corrective action as described in the following table:
Information output to bb....bb
Description
Action to take
A data type is not VARCHAR or VARBINARY
You cannot specify branch specification for a column whose data type is other than the VARCHAR type or the VARBINARY type.
Use one of the following methods to correct the SQL statement:
-
If you want to use a data type other than the VARCHAR type or the VARBINARY type for the column:
Delete the branch specification from the SQL statement.
-
If you want to specify branch specification:
Change the data type of the column to the VARCHAR type or the VARBINARY type.
The table option BRANCH ALL is specified
You cannot specify branch specification for a table column that is defined by specifying the table option BRANCH ALL.
Use one of the following methods to correct the SQL statement:
-
If you want to specify the table option BRANCH ALL:
Delete the branch specification from the SQL statement.
-
If you want to specify branch specification:
Delete the table option BRANCH ALL from the SQL statement.
The table option STORAGE FORMAT COLUMN is specified
You cannot specify branch specification for a table column that is defined with the table option STORAGE FORMAT COLUMN specified.
Use one of the following methods to correct the SQL statement:
-
If you want to define the table as a column store table:
Delete the branch specification from the SQL statement.
-
If you want to specify branch specification:
Define the table as a row store table instead of a column store table:
The table option STORAGE FORMAT COLUMN is not specified
You cannot specify compression-type specification for a table column that is defined without the table option STORAGE FORMAT COLUMN specified.
Use one of the following methods to correct the SQL statement:
-
If you want to define the table as a row store table:
Delete the compression-type specification from the SQL statement.
-
If you want to specify compression-type specification for a column:
Specify the table option STORAGE FORMAT COLUMN to define the table as a column store table.
The table option BRANCH ALL was specified when the table was defined
You cannot add a column for which branch specification is specified to a base table for which BRANCH ALL was specified when the table was defined.
Delete the branch specification from the SQL statement.
The table is a column store table
You cannot add a column for which branch specification is specified to a column store table.
Delete the branch specification from the SQL statement.
You cannot specify chunk-archive specification for a column store table.
A column store table cannot be changed to an archivable multi-chunk table by using the ALTER TABLE statement.
If you need an archivable multi-chunk table, change the column store table to a row store table. For details about how to change a column store table to a row store table, see Changing a column store table to a row store table in the HADB Setup and Operation Guide.
If you change the column store table to a row store table, specify chunk-archive specification when you execute the CREATE TABLE statement to define the table as an archivable multi-chunk table.
The table is a row store table
You cannot add a column for which compression-type specification is specified to a row store table.
Delete the compression-type specification from the SQL statement.
-