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
 

 

Cursor/Locking question

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

New User


Joined: 08 Feb 2008
Posts: 4
Location: India

PostPosted: Fri Jul 31, 2009 10:48 pm    Post subject: Reply to: cursor with WITH HOLD option
Reply with quote

Hi,

This is something i am wondering...

I have a cursor , which in declare section i have given to fetch only 50 rows at a time , then the locking which is used is CS, then if i am updating any one of the row then the rest 49 rows are free to be updated by others yes or no ..please let me know.
Back to top
View user's profile Send private message

Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Sat Aug 01, 2009 12:59 am    Post subject:
Reply with quote

Please start a new thread for a new question.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Aug 01, 2009 6:55 am    Post subject:
Reply with quote

Hello and welcome to the forum,

Quote:
if i am updating any one of the row then the rest 49 rows are free to be updated by others yes or no
If i understand the question - No, as there may be other rows to update and if they were freed, the update would fail.
Back to top
View user's profile Send private message
somdatta28

New User


Joined: 08 Feb 2008
Posts: 4
Location: India

PostPosted: Mon Aug 03, 2009 10:32 pm    Post subject: Reply to: Cursor/Locking question
Reply with quote

Thanks for the reply... I tested it out and it works fine.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Aug 03, 2009 11:41 pm    Post subject: Reply to: Cursor/Locking question
Reply with quote

Good to hear it is working - thanks for letting us know icon_smile.gif

d
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting -504 Cursor Name GTT-ARTS-CUR... Robin Sulsona DB2 2 Fri Mar 17, 2017 1:43 am
No new posts Asynchronous CICS Processing Question moezbud CICS 0 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 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
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us