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
 

 

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: 6966
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 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
No new posts DB2 Stored Procedure - Dynamic SQL - ... GuyC DB2 2 Wed Feb 17, 2016 5:10 pm
No new posts ISREDIT - Position Cursor on the Comm... Tarique Anwer TSO/ISPF 5 Wed Feb 03, 2016 12:44 pm
No new posts Need a cursor to achieve the below re... sandeep kumar302 DB2 10 Tue Mar 31, 2015 10:52 am


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