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?
"KalpanaPai" <kalpanapaihotmail.com> wrote in message
news:8b77f6f5.0308241906.21eb6f22posting.google.c om...> 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