SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 06:30 PM
| ||||
| ||||
 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      |
|
04-19-2008, 06:30 PM
| |||
| |||
| Re: How to retrieve first 50 rows , next 50 rows and so on in Informix 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.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 > Kalpana |
|
04-19-2008, 06:31 PM
| |||
| |||
| 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 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 . 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 |
|
04-19-2008, 06:31 PM
| |||
| |||
| Re: How to retrieve first 50 rows , next 50 rows and so on in Informix 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? |
|
04-19-2008, 06:32 PM
| ||||
| ||||
| Re: How to retrieve first 50 rows , next 50 rows and so on in Informix Java , java script, JSP , HTML and Webserver is Tomcat Thanks Heaps!!!! John Carlson <john_carlson@whsmithusa.com> wrote in message news:<a7omkvoiah2g6amjo03s21rl8d29gccc8p@4ax.com>. .. > 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? |
Linear Mode
