| Author |
Message |
deen
New User
Joined: 20 Aug 2003
Posts: 3
|
|
|
|
Hi ... Can i use scrollable cursor in pseudo conversational programming. As far as i know in this type of programming we issued exec cics return and will lost the cursor position. How can i maintain the cursor position? I already try with hold option but it doesn't work. 
For your info, i'm using cobol, cics, db2 and bms.
Thanks in advanced |
|
| Back to top |
|
 |
References
|
 Posted: Wed Aug 20, 2003 9:27 pm Post subject: Re: scrollable cursor |
|
|
|
|
mcmillan
Site Admin
Joined: 18 May 2003
Posts: 846
Location: India
|
|
|
|
| Before returning the program just move EIBCPOSN to commarea and then receive this value on your new transaction. |
|
| Back to top |
|
|
deen
New User
Joined: 20 Aug 2003
Posts: 3
|
|
|
|
Thanks for reply but my question is about scrollable cursor. The answer that u gave to me is about positining cursor in bms. Ok, i'll put my question like this to make others easier to understand
| Quote: |
How to maintain the cursor position for scrollable purposes (forward & backward) in pseudo conversational programming. As far as i understand the cursor position will lost after "EXEC CICS RETURN" was issued. For your info i'm using COBOL, CICSTS22, DB2 V7.
I would like to have one sample application program using Scrollable cursors. Please help me out in getting one sample program
Thanks in advanced |
|
|
| Back to top |
|
|
DNelsonPNC
EXPERT
Joined: 15 Jun 2003
Posts: 10
Location: North Carolina
|
|
|
|
To my knowledge, there is no way to maintain a DB cursor across CICS transaction invocations.
A way to do this would be to retrieve all the data and place in CICS TS queue. (If not TOO Large!). Then keep a pointer to the data last retrieved location is application COMM AREA. Just be very carefull to make sure you DELETE all the data when the application is done or you will cripple CICS. |
|
| Back to top |
|
|
|
|
