Hitachi

Hitachi Advanced Database Messages


KFAA30424-E

The specification of the value of "aa....aa" of a "LIKE predicate" is invalid. (details = bb....bb) (M+J+O)

The specification of the value expression specified for aa....aa of the LIKE predicate is invalid.

aa....aa:

escape character: Escape character

bb....bb: Cause of the error
  • data length error: The data length of the value expression specified for the escape character is invalid. <SQLSTATE: 22019>

  • escape character value error: The data content of the value expression specified for the escape character is invalid. <SQLSTATE: 2250A>

S:

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

Action:

Correct the specified escape character, and then retry the operation.