Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

scrollable cursor

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
deen

New User


Joined: 20 Aug 2003
Posts: 3

PostPosted: Wed Aug 20, 2003 9:27 pm    Post subject: scrollable cursor
Reply with quote

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. icon_cry.gif

For your info, i'm using cobol, cics, db2 and bms.


Thanks in advanced
Back to top
View user's profile Send private message

mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1202
Location: India

PostPosted: Wed Aug 27, 2003 3:44 pm    Post subject: Re
Reply with quote

Before returning the program just move EIBCPOSN to commarea and then receive this value on your new transaction.
Back to top
View user's profile Send private message
deen

New User


Joined: 20 Aug 2003
Posts: 3

PostPosted: Sat Aug 30, 2003 8:31 pm    Post subject:
Reply with quote

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
View user's profile Send private message
DNelsonPNC

EXPERT


Joined: 15 Jun 2003
Posts: 10
Location: North Carolina

PostPosted: Tue Sep 02, 2003 1:37 am    Post subject: Scrollable Cursor
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm
No new posts Getting -504 Cursor Name GTT-ARTS-CUR... Robin Sulsona DB2 2 Fri Mar 17, 2017 1:43 am
No new posts Release of Adabas Cursor mohitsethi All Other Mainframe Topics 1 Mon Feb 06, 2017 8:36 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts Variable for cursor names ravikumar15 DB2 5 Sun Jul 17, 2016 7:08 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us