sql to get listing from paging

Question

I have a user list table on my listing page. The data needs to be paged, so how can I make SQL page the data for me (ie. pull the data in sets of 10 records from the table)?

Answer 1

Informix has clauses analogous to, but different from, LIMIT and OFFSET:

SELECT SKIP n LIMIT m ...

You can use FIRST in place of LIMIT.

See the IDS 11.70 InfoCenter, or similar locations for earlier versions of IDS.