KFAA31652-E
A range index cannot be defined in column "aa....aa". (reason = bb....bb) (M+J+O)
A range index cannot be defined for the following columns: <SQLSTATE: 42IA8>
-
A column whose type is CHAR and whose length exceeds 32 bytes
-
A column whose type is VARCHAR
-
A column whose type is BINARY
-
A column whose type is VARBINARY
- aa....aa:
-
Column name
- bb....bb: Reason why range index cannot be defined
-
-
data type is CHAR and data length is longer than 32 bytes: The data type of the column is CHAR and the data length exceeds 32 bytes.
-
data type is VARCHAR: The data type of the column type is VARCHAR.
-
data type is BINARY: The data type of the column type is BINARY.
-
data type is VARBINARY: The data type of the column type is VARBINARY.
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
A range index cannot be defined for the column aa....aa, so change the database design (column data type, indexed columns, index type, and so on).