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

I know that Select first 50* from Table will get only 50 rowsBut i want to know from the application side , if the query returns more rows , i want to get them in 50's and display and next 50 etc, in that way the query will not kill the memory if more sessions are connected without bringing the whole data to the buffer . Any Solution ????????/ Thanks in advance Kalpana kalpanapai@hotmail.com (KalpanaPai) 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

On 25 Aug 2003 14:27:45 -0700, kalpanapai@hotmail.com (KalpanaPai) wrote: >I know that >Select first 50* from Table will get only 50 rows>But i want to know from the application side , if the query returns >more rows , i want to get them in 50's and display and next 50 etc, in >that way the query will not kill the memory if more sessions are >connected without bringing the whole data to the buffer . > What application / development language are you using?