|
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 |
|
|
|
|
