I had a problem that after fetching 3 rows using cursor i am send ding map if enter key is pressed it should fetch the next three rows but cursor gets closed . i have read in a manual that i should use > then sigh after where close.
Joined: 31 May 2006 Posts: 200 Location: Netherlands
Every transaction in CICS counts as a LUW (logical unit of work) so when presseed enter you returned the control to CICS there by closing the cursor(If you do not specify explicit commit it closes after LUW) . Try using WITH HOLD option in cursor declaration.