The Informix database interfaces support the following FETCH statements:
FETCH NEXT
FETCH FIRST
FETCH PRIOR
FETCH LAST
Informix FETCH NEXT
Informix FETCH FIRST, FETCH PRIOR, and FETCH LAST