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
 
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 JES2 EXIT 6 QUESTION Randy Horowitz All Other Mainframe Topics 30 Tue Feb 06, 2018 5:47 pm
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts question about dfsms management clas... Hervey Martinez IBM Tools 0 Tue Oct 10, 2017 6:19 pm
No new posts Question related to Data dictionary f... rexx77 SYNCSORT 3 Thu Aug 31, 2017 7:23 am

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