Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to calculate and maintain Row position in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
seema_285

New User


Joined: 14 Oct 2010
Posts: 13
Location: pune

PostPosted: Mon Feb 25, 2013 3:32 pm    Post subject: how to calculate and maintain Row position in DB2
Reply with quote

Hi ,

I have a requirement like below :

for particular data if there are more than 500 records in table then at single point of time <= 500 recs will be fetched and displayed on web.

e.g. if there are 1400 records, then during first call of SP, first 500 i.e. 1st to 500th records will be displayed. at this time NEXT link on web will be enabled and when user clicks NEXT , 501th to 1000th records should be fetched and displayed. at this time both PREV and NEXT links will be enabled. if user clicks NEXt then 1001th to 1400th records should be displayed. if user Clicks PREV then in first PREV 501th to 1000th records should again fetched and displayed and in second PREV click 1st to 500th records should be diplayed.

To fulfil this, I wanted to know if we can calculate and maintain row position , and setting the upper and lower limit of this row position can we fetch data in DB2 cursor ?

Please help on this or any other suggestion/reference will be highly appreciated.

Thanks in advance.
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2435
Location: Netherlands, Amstelveen

PostPosted: Mon Feb 25, 2013 7:33 pm    Post subject:
Reply with quote

Look into "scrollable cursors".
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Wanted to calculate TRK when i have B... Balu5491 JCL & VSAM 7 Wed Jul 19, 2017 5:43 pm
No new posts How to calculate an specific transact... lind sh CICS 2 Tue Sep 13, 2016 9:20 pm
No new posts ISREDIT - Position Cursor on the Comm... Tarique Anwer TSO/ISPF 5 Wed Feb 03, 2016 12:44 pm
No new posts Calculate a timeframe with DFsort Gerd Hofmans DFSORT/ICETOOL 6 Thu Jan 14, 2016 5:30 pm
No new posts Adjust Heading Position in Easytrieve thesumitk CA Products 4 Mon Dec 21, 2015 3:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us