Hi
I have requirement to extract data from table(which is common to many processes) and update the same table But in the mean time no other process should read the same data and update. We are doing this in single Job.
Could some one advise on this how to achieve this?
Thanks
Naga
Lock data Rows in table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks Ray,ray.wurlod wrote:Research "transaction isolation level".
I had gone through the docs and found Repeatable Read Isolation level. And have few queries on this.
As it says, It locks the row(whichever has been read) does it allows to update the in the same process( i mean reading as reference and updating in same process)
And cannot be read the same row by any other process? but same row can be read n no.or times by same process?
-
- Participant
- Posts: 31
- Joined: Mon Jun 28, 2010 5:15 am
- Location: pune
Re: Lock data Rows in table
Yes , it allows the first process to update the rowsAs it says, It locks the row(whichever has been read) does it allows to update the in the same process( i mean reading as reference and updating in same process)
No, all pocesses will be able to read the row, they will not be able to update the row.And cannot be read the same row by any other process? but same row can be read n no.or times by same process
In addition to this,there can be new records added by the any other process as well