Note: If you specify the NUMBER option in the PROC SQL statement when you create your view, the ROW column appears in the output. However, you cannot order by the ROW column in subsequent queries. See ...

In fact, it can't - different DBs use different SQL syntax. Therefore it's not at all unreasonable for a JPA implementation to add an "order by" if it's necessary to implement setFirstResult ...