Hitachi

Hitachi Advanced Database Messages


KFAA30149-E

"ROW" is used incorrectly. (M+J+O)

The way ROW is specified contains one of the following errors. <SQLSTATE:42572>

  • ROW was specified in a query that specified a set function.

  • ROW was specified in a query that specified a window function.

  • ROW was specified in a query that specified DISTINCT.

  • Something other than a dynamic parameter was specified in the insertion value or update value for ROW.

  • ROW was specified in an expression other than the selection expression in the outermost query specification.

  • ROW was specified in a query expression in the viewed table.

  • In a joined table specification, ROW was specified for a table for which the null value is specified.

  • ROW was specified in a query expression body in a WITH clause.

  • ROW was specified in a query that specifies a set operation.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the SQL statement.