Hitachi

Hitachi Advanced Database Messages


KFAA31214-E

There are no format elements in the format specification of a scalar function. (function name = aa....aa, information = bb....bb, query number = cc....cc) (M+J+O)

A required element is missing from the format specification of scalar function "aa....aa". <SQLSTATE: 2250G>

aa....aa:

Scalar function name

bb....bb: Element required for the format specification:
  • YEAR: Year

  • MONTH: Month

  • DAY: Day

  • HOUR: Hour

  • MINUTE: Minute

  • SECOND: Second

  • NUMERIC: Numeric element

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 format specification.