MVSFORUMS.com

sanat · Posted: Thu May 08, 2003 8:59 am Post subject: CICS DB2 Program technique

Hi,
I have to write a CICS programto browse a table. Since I will be using Pseudoconversation technique, when the RETURN TRANSID is issued, the program will close the cursor. In between fi I have opted for a page down, do I have to open the cursor again and fetch until the last record browse is crossed ?
Is there any other way of efficient coding? Can the cursor be kept open in an RETURN TRANSID command?

Thanks,
Sanat.

Glenn · Beginner Joined: 23 Mar 2003 Posts: 56 Topics: 3

Have a look at this....it works for DB2 for version 6 and down....in Version 7 you can use a scrollable cursor and make it work. Hope it helps.

http://www.mvsforums.com/helpboards/viewtopic.php?t=118

ravii_cbe · Posted: Mon Jun 02, 2003 9:02 am Post subject:

By using scrolling program U can avoid the problem. First you fetch all the records and write it in a TSQ. By using item option you can read the perticular record.
_________________
Thanks & Regards
M. RaviShankar