Hitachi

Hitachi Advanced Database Messages


KFAA31127-E

The specification method of inverse distribution functions is invalid. (function name = "aa....aa", reason = bb....bb, query number = cc....cc) (M+J+O)

The specified inverse distribution function is invalid.

aa....aa:

Inverse distribution function name

bb....bb: Cause of the error
  • different column name: Two or more inverse distribution functions with different column names specified in the aggregated argument are specified. <SQLSTATE: 427B9>

  • value expression: A different inverse distribution function than the one with a value expression specified in the aggregated argument is specified. <SQLSTATE: 427BA>

  • different sort specification: Multiple inverse distribution functions that contain different sort order specifications in the sort specification of a WITHIN group specification are specified. <SQLSTATE:427BB>

cc....cc: Position number of the query that specified the inverse distribution function

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

S:

Ignores this SQL statement.

Action:

Correct the SQL statement.