Does Informix SQL support LIMIT?

[Anon]

I'm trying to create as follows (for example):

Showing Records 1-10 of 137
[ < Previous 1 2 3 4 5 6 7 Next > ]

However, I am connecting to informix database, which the SQL select statement doesn't support the limit like mysql; therefore, I cannot set the offset. Please give me some advice whether there is any other way to do it. Thank you very much

[Anon]

I've never seen LIMIT in Informix's SQL. I believe the best way around that is to put all the selected data into an array and point to that instead.

Hank