embedded sql select locks

Question

Question

Adel Elsayed · Sep 22, 2021

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.

Product version: Caché 2017.1

Discussion (4)1

Log in or sign up to continue

Vic Sun · Sep 22, 2021

Can you identify what is being locked? Is it possible the lock is on something internal, and not the table itself?

0 0

score 0 · Answer 1 · 2021-09-22T09:58:46-04:00

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.

score 0 · Answer 2 · 2021-09-22T11:46:48-04:00

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

%nolock should specify not locking when used with select

score 0 · Answer 3 · 2021-09-22T11:44:41-04:00

Adel Elsayed · Sep 22, 2021

i am sure lock is on the queried global

0 0