View previous topic :: View next topic
|
Author |
Message |
somdatta28
New User
Joined: 08 Feb 2008 Posts: 4 Location: India
|
|
|
|
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 |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
Please start a new thread for a new question. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
somdatta28
New User
Joined: 08 Feb 2008 Posts: 4 Location: India
|
|
|
|
Thanks for the reply... I tested it out and it works fine. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thanks for letting us know
d |
|
Back to top |
|
|
|