Hitachi

Hitachi Advanced Database Messages


KFAA30453-E

There is an error in the specification method of a scalar function argument. (function name = "aa....aa", reason = "bb....bb", query number = cc....cc) (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 was 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>

  • data type: The data type that was specified cannot be used. <SQLSTATE: 42785>

  • combination: An error occurred when the value expression data type was combined with the result data type. <SQLSTATE: 42807>

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.