IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Process records after n rows from a cursor


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ba.appaiah

New User


Joined: 18 Sep 2008
Posts: 3
Location: BANGALORE

PostPosted: Wed Sep 24, 2008 4:35 pm
Reply with quote

Hi,

i have a cursor. I have to process records only after n rows in the cursor. How do i go about it...
Back to top
View user's profile Send private message
anil.csk

New User


Joined: 22 Oct 2007
Posts: 16
Location: Noida

PostPosted: Wed Sep 24, 2008 6:28 pm
Reply with quote

For processing the cursor after n of records, first use a cursor with the optimize for Nth number of rows from this cursor gets the last record number:
By using this record number declare another cursor by using the where condition giving this record number by USING this you get your answer..

Suggestion are welcome..
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts To get the count of rows for every 1 ... DB2 3
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
Search our Forums:

Back to Top