How to retrieve first 50 rows , next 50 rows and so on in Informix

Hi All Is there any equivalent command for SET ROWCOUNT or LIMIT in INFORMIX to get the first 50rows, next 50 rows and so on if query returns 2500 rows . So that the number of rows retrived for each page can be limited in each session. Any clues would be appreciated. Thanks in Advance Kalpana

Hi, You could declare a scroll cursor. Using a counter you could fetch the first 50 records, doing a fetch next and increase the counter until 50 records are read. But it would be nicer to limit the number of selected rows. For example: select first 50...., select next 50...., select previous 50.... Is this possible? Danny "KalpanaPai" <kalpanapai@hotmail.com> wrote in message news:8b77f6f5.0308241906.21eb6f22@posting.google.com... > Hi All > > Is there any equivalent command for SET ROWCOUNT or LIMIT in INFORMIX > to get the first 50rows, next 50 rows and so on if query returns 2500 > rows . > > So that the number of rows retrived for each page can be limited in > each session. > > Any clues would be appreciated. > Thanks in Advance > Kalpana