Background documentation-7036: ROWNO- specification not allowed in this context Locate this document in the navigation structure

 

Explanation

  1. The specification ROWNO may only be used in QUERY statements. The QUERY statement must not contain a UNION, EXCEPT or INTERSECT specification.

  2. The ROWNO predicate can be used within the search condition, in the form ROWNO < <rowno_spec> or ROWNO <= <rowno_spec>, that is, ROWNO is on the left of the operator.

  3. The ROWNO predicate may occur only once in a search condition. It must be connected with other predicates by logical AND.

User Response

  1. In the case of UNION, EXCEPT or INTERSECT, the effect can be achieved by two successive QUERY statements.

  2. Correct the search condition in the SQL statement accordingly.