Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
db2 cursor name

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
lineesh_kumar

New User


Joined: 20 Feb 2006
Posts: 6

PostPosted: Thu Jul 01, 2010 9:16 pm    Post subject: db2 cursor name
Reply with quote

Hi,

I have 4 cursor which will be executing depending on the condition.

Now I have like

evaluate true
when 1 open cursor1
when 2 open cursor2
when 3 open cursor3
when 4 open cursor4
end

Instead can I use like open ws-cursor, set the ws-cursor in working storage with 4 88 levels of cursor1, cursor2 etc . I will set the 88 level before the opening of the cursor. I know this is some kind of dynamic processing. But is there a way for doing this?

Responses are appreciated.

Regards
Lineesh
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Thu Jul 01, 2010 9:48 pm    Post subject:
Reply with quote

the syntax of the declare cursor, open cursor, close cursor and fetch cursor do not allow for the cursor name to be contained in/ or the value of a w-s variable.

if you have 4 cursors, you will need four declare/open/fetch/close cursor db2 api calls.
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
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

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us