embedded sql select locks
i noticed -by reading .INT files of one class- that some of embedded sql select statements code blocks translates into code that uses lock command.
even if i use %nolock in the select, still cursors and arrow referencing notations "->" have the same results.
Comments
Good morning Elsayed. Forgive me if I'm not understanding everything, but is it possible that the %NOLOCK keyword just telsl the IRIS locking mechanism to ignore all locking requests from this query. That might be an easier thing to implement than not putting them in the INT code. Just a thought. Let me know if I'm right or wrong. And good luck with it.
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…
%nolock should specify not locking when used with select
Can you identify what is being locked? Is it possible the lock is on something internal, and not the table itself?
i am sure lock is on the queried global