Hitachi

Hitachi Advanced Database Messages


KFAA31380-E

An error occurred during execution of string concatenation. (info1 = aa....aa, info2 = bb....bb, info3 = cc....cc) (M+J+O)

An error occurred during string concatenation. The result of the scalar function CONCAT or the concatenation operation exceeded the maximum data length (cc....cc bytes) of the result. <SQLSTATE:22001>

aa....aa: Function or operation that generated the error
  • function: Scalar function CONCAT

  • operator: Concatenation operation

bb....bb: Cause of the error 1
  • data length: The result of concatenating strings exceeded the maximum data length of the result.

cc....cc: Cause of the error 2

If bb....bb is data length, the maximum data length of the result is output.

S:

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

Action:

Correct the SQL statement so that the result of the scalar function CONCAT or the concatenation operation does not exceed the maximum data length (cc....cc bytes) of the result.