Is there a way to perform an %Prepare()/%Execute() that will wait until the record being queried is unlocked by another process?
Ex:
Process 1 - is opening record, updating, then saving. NOTE: this is using embedded SQL
InterSystems Caché is a multi-model DBMS and application server. See more details here.