The LIMIT Keyword (IDS)

For Dynamic Server, LIMIT is a keyword synonym for the FIRST keyword in 3the Projection clause. You cannot, however, substitute LIMIT for FIRST in 3other syntactic contexts where FIRST is valid, such as in the FETCH statement.

Extended Parallel Server does not support the LIMIT keyword, and it returns 3an error if FIRST is not immediately followed by a non-negative literal integer.