MVSFORUMS.com

rameshb

hi

i am using the following cursor for displaying the values in my online screen for the first time

SELECT A,B,C FROM XYZ
ORDER BY A,B

any one can help me how to write forward and backward scrolling cursor for this

thanks,
ram

kolusu · Posted: Wed Feb 18, 2009 3:47 pm Post subject:

rameshb,

Please search before posting. Check this link. This link shows reading from a TSQ , you need to implement the same logic to DB2 cursor

http://www.mvsforums.com/helpboards/viewtopic.php?t=3071&highlight=pageup

Kolusu

rameshb · Posted: Wed Feb 18, 2009 10:18 pm Post subject:

hi kolusu,

i mean i need sql query

select from a,b,c from xyz
where (x = :tempx and y>:tempy) or (x>:tempx)

whether this query will work to fetch next set of records in forwaard cursor

thanks

kolusu · Posted: Thu Feb 19, 2009 11:44 am Post subject:

rameshb,

Dibakar · Posted: Tue Feb 24, 2009 12:07 pm Post subject:

Isn't this the right situation to use scrollable cursor?

srini_igsi · Posted: Fri Mar 20, 2009 7:54 am Post subject:

Hi Kolusu,

Is there a way to implement the similar logic with a DATE field in the where caluse but with duplicate values.

I believe we must have at lease one unique field on the screen/DB to control the paging otherwise we can't implement this logic using the SQL queries. The other way around is TSQ.

Please correct me if I'm wrong.
_________________
Thanks,
-Srini

Dibakar · Posted: Fri Mar 27, 2009 1:38 pm Post subject:

Looks like with scrollable cursor you don't have the issue.