|
View previous topic :: View next topic
|
| Author |
Message |
navneet.dewangan
New User
Joined: 09 Oct 2005
Posts: 22
Location: INDIA
|
|
|
|
hello sir,
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.
could any one plz tell me .
thanks a lot for all ur support
 [/code] |
|
| Back to top |
|
 |
perez_a
New User
Joined: 02 Feb 2006
Posts: 25
Location: Italy
|
|
|
|
HI,
U CAN TRY TO USE THE CLAUSE "WITH RETURN" WHEN DEFINE THE CURSOR.
TELL ME IF IT IS CORRECT
BYE ALEX |
|
| Back to top |
|
|
prasadvrk
Active User
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. |
|
| Back to top |
|
|
|
|
