Hitachi

Hitachi Advanced Database Messages


KFAA31126-E

"Null ordering" cannot be specified in the "sorting specification list" of aa....aa. (function name = bb....bb) (M+J+O)

The null-value sort order cannot be specified in the sort specification list in aa....aa. <SQLSTATE: 427A5>

aa....aa: Location where the sort specification list is specified
  • within group specification: WITHIN group specification

  • ARRAY_AGG set function: ARRAY_AGG set function

bb....bb: Set function name

If aa....aa is ARRAY_AGG set function, three asterisks (***) are displayed.

S:

Ignores this SQL statement.

Action:

Delete the specification of the null-value sort order.