Progress OpenEdge
Member
Qn 18: What is the default locking level for reading records in Progress? Give some reasons why this should be used or not!
Ans: Default locking when no explicit lock is given is SHARE-LOCK.
When another user reads the same record and starts updating, the record gets locked for the second user. If then, the first user starts updating, he needs to wait till the second user releases.
It is best to read the record in NO-LOCK if it is display only purpose.
It is best to read the record in EXCLUSIVE-LOCK if it is for update, so others can retrieve only in NO-LOCK mode.
Ans: Default locking when no explicit lock is given is SHARE-LOCK.
When another user reads the same record and starts updating, the record gets locked for the second user. If then, the first user starts updating, he needs to wait till the second user releases.
It is best to read the record in NO-LOCK if it is display only purpose.
It is best to read the record in EXCLUSIVE-LOCK if it is for update, so others can retrieve only in NO-LOCK mode.