Hitachi

Hitachi Advanced Database Messages


KFAA31373-E

There is an error in the specification method of a scalar function argument. (function name = "aa....aa", reason = "bb....bb") (M+J+O)

There is an error in the specification format of scalar function aa....aa.

aa....aa:

Scalar function name

bb....bb: Cause of the error
  • data length insufficient: The result data is too short. <SQLSTATE: 22001>

  • overflow: An overflow occurred. <SQLSTATE: 22003>

  • format: There is an error in the character string format of the data to be converted. <SQLSTATE: 22018>

  • value: The value of the data to be converted is invalid. <SQLSTATE: 22018>

  • out of range: A value outside of the range that can be converted to the elements specified in the format specification is specified in the target data. <SQLSTATE: 22522>

S:

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

Action:

Correct the SQL statement.

Note that this error might be output by a CONVERT scalar function that was generated internally when viewed tables defined prior to upgrading the version are searched after the version is upgraded. If this occurs, re-define the viewed table. For details about the conditions that generate the scalar function CONVERT, see Notes on version upgrading in Upgrading the HADB server version in Building a System of the HADB Setup and Operation Guide.