Hitachi

Hitachi Advanced Database Messages


KFAA31420-E

The data length of an argument specified in the scalar function "aa....aa" is longer than bb....bb bytes. (query number = cc....cc) (M+J+O)

The data length of an argument specified in the scalar function "aa....aa" exceeds bb....bb bytes. <SQLSTATE: 42819>

aa....aa: Scalar function name
  • BIN: Scalar function BIN

  • HEX: Scalar function HEX

bb....bb: Maximum byte length
  • 4,000: Maximum byte length that can be specified for an argument of the scalar function BIN

  • 16,000: Maximum byte length that can be specified for an argument of the scalar function HEX

cc....cc: Position number of the query that specified aa....aa

For details about query position numbers, see 1.5 Query position numbers.

S:

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

Action:

Correct the SQL statement.

If aa....aa is BIN, make sure that the maximum data length of an argument in the scalar function BIN is 4,000 bytes or less.

If aa....aa is HEX, make sure that the maximum data length of an argument in the scalar function HEX is 16,000 bytes or less.