Hitachi

Hitachi Advanced Database Messages


KFAA31659-E

A text index cannot be defined in column "aa....aa". (reason = bb....bb) (M+J+O)

A text index cannot be defined for the following columns: <SQLSTATE: 42IB2>

  • Columns whose data type is not CHAR or VARCHAR

aa....aa:

Column name

bb....bb: Cause of the error
  • data type is not CHAR or VARCHAR: An attempt is made to define a text index for a column whose data type is neither CHAR nor VARCHAR.

S:

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

Action:

Revise the column for which to define the text index.