Hitachi

Hitachi Advanced Database Messages


KFAA30264-E

The window function "aa....aa" is invalid. (reason = bb....bb, query number = cc....cc) (M+J+O)

Window function aa....aa is invalid.

aa....aa:

Window function name

bb....bb: Cause of the error
  • none "window order" clause: No window order clause is specified. <SQLSTATE: 427H0>

  • specified "window frame" clause: A window frame clause is specified. <SQLSTATE: 427H1>

  • specified "window order" clause: A window order clause is specified. <SQLSTATE: 427H2>

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.