I want understand what is the reason behind in case of find
Normally triggers will execute first session and schema level for create,delete,assign,write except find trigger on same table
In case of find trigger first schema and session will execute
can you please explain or give example is...
inproc internal procedure is there in main.p and sub.p programs, after added sub.p as a super-procedure in main.p.
in this case how to use IN SUPER Keyword ? please explain ?
/* main.p */
define var hdl as handle.
run sub.p persistent set hdl.
this-procedure:add-super-procedure(hdl).
run...
Thanks for your answer.
i hope you explained for batch jobs ryt. if it is possible can you provide with one sample example program to understand clearly.
@Cringer you are correct. but my question is in that code it is raising the buffer scope and transaction scope in procedure level due to update statement, its behaving like free reference. so can we say for each also behaving like free reference in such situations?
Hi,
i am able to see procedure level buffer scope and transaction scope in below code
for each customer exclusive-lock:
end.
update name.
can any one explain can we say for each also free reference in some situations like in above scenario.
...\Practise\scope.p 09/13/2019...
Thanks Rob for explanation, if some one ask should i say transaction is not active still transaction function return true in application level until unless changes on the database level.
Hi,
Help me regarding my doubt.
transaction is active or not in below block query?
for each customer exclusive-lock:
---<no update or assign statements>
end.
when i checked with "transaction" keyword inside block its saying as "yes", but _Trans (VST) table "_Trans-state" showing as nothing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.