Progress_Learner
Member
Hello Guys, hope you all are well.
I was surprised to see that For First behaves different from For each. Each iteration of For each is a transaction (in X lock) and after end of For Each, record scope is not available.
But with For First, scope is available and lock is downgraded to Shared lock. Checked for Promon. First and Each are just attributes of For block then why is that difference. Please suggest.
Thanks and Regards,
Learner
I was surprised to see that For First behaves different from For each. Each iteration of For each is a transaction (in X lock) and after end of For Each, record scope is not available.
But with For First, scope is available and lock is downgraded to Shared lock. Checked for Promon. First and Each are just attributes of For block then why is that difference. Please suggest.
Thanks and Regards,
Learner