Hitachi

Hitachi Advanced Database Messages


KFAA31216-E

The specification of the "LIMIT" clause is invalid. (reason = aa....aa) (M+J+O)

The specified LIMIT clause is invalid.

aa....aa: Cause of the error
  • correlated subqueries: The LIMIT clause is specified for a derived table that has an external reference beyond the derived table for which the LIMIT clause is specified. For details, see Explanation of specification format in Specification format and rules for subqueries in the manual HADB SQL Reference. <SQLSTATE: 427I3>

  • specified position: The position of the specified LIMIT clause is invalid. <SQLSTATE: 427I4>

  • specified position of offset: The position at which the offset of the first row to return is specified is invalid. <SQLSTATE: 427I6>

S:

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

Action:

Correct the SQL statement.