Hitachi

Hitachi Advanced Database Messages


KFAA30614-E

A B-tree index cannot be created in column "aa....aa". (reason = "bb....bb") (M)

Columns of the following data types cannot be specified for B-tree indexed columns: <SQLSTATE: 42I16>

  • BINARY type

  • VARBINARY type

aa....aa:

Name of the column whose data type caused the error

bb....bb: Cause of the error
  • The data type of the column is BINARY: The data type of the column is BINARY.

  • The data type of the column is VARBINARY: The data type of the column is VARBINARY.

S:

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

Action:

A B-tree index cannot be defined for column aa....aa. Check and, if necessary, revise the column data type, indexed column, or other aspects of the database design.