Re: fetch first/next 20 rows

You can use the select first <n> from table. See "first n" clause in SQL manual select clause. |---------+----------------------------> | | janeg@mhcommunica| | | te.com (jane) | | | Sent by: | | | owner-informix-li| | | st@iiug.org | | | | | | | | | 09/01/2003 09:04 | | | PM | | | Please respond to| | | janeg | | | | |---------+----------------------------> >-------------------------------------------------------------------------------------------------------------------------------| | | | To: informix-list@iiug.org | | cc: | | Subject: fetch first/next 20 rows | | | >-------------------------------------------------------------------------------------------------------------------------------| Our web application wants to display huge data page by page without storing the data in the session(because of the shortage of memory). We are using Tomcat as the web server and Informix 9.21 as the database server. I search all the documents about Informix and can't find the function that i can fetch first or next part of the rows. Can anyone tell me how to do this? How can i integrate Informix Web Datablades with my web application? Thanks in advance sending to informix-list