Fetch record from table

avinash pandey · New User Joined: 10 Apr 2008 Posts: 17 Location: Bangalore

i HAVE a table -

01 SACHIN
02 SAURAV
03 KAPIL
04 NAVED
05 SURABHI

i have cics+db2 program, i have to fetch first record while executing the program for the firs time. then fetch the second record while executing the program for the second time. these 5 record i want to fetch it all the N iteration of the program.

how can the pointer could passed internally for the iteration. Could anybody assist me in this regard

dick scherrer · Posted: Sat May 30, 2009 3:24 pm

Hello,

How is this program repeatedly invoked?

If some module calls this module, you could put a cursor in the first (calling) module and pass the "current" id to the called module each time a new value is fetched from the cursor.