Pavan Yadav
Member
Hi All,
I just stuck with a basic understanding of trigger and needs to have some discussion on the same.
I don't have any real life scenario as of now, so trying to understand this with a basic example.
I defined Schema Level Find Trigger on my DB and Session Level Find trigger in my Program. While executing this, with no doubts, Schema Level will trigger first and then the Session Level. But, can you please assist if there is any way I can reverse this action and can execute Session level first and then Schema Level.
I tried using Override, but that triggers only session level and not schema Level.
Sample codes are as:
Schema Level:
Session Level:
I just stuck with a basic understanding of trigger and needs to have some discussion on the same.
I don't have any real life scenario as of now, so trying to understand this with a basic example.
I defined Schema Level Find Trigger on my DB and Session Level Find trigger in my Program. While executing this, with no doubts, Schema Level will trigger first and then the Session Level. But, can you please assist if there is any way I can reverse this action and can execute Session level first and then Schema Level.
I tried using Override, but that triggers only session level and not schema Level.
Sample codes are as:
Schema Level:
Code:
TRIGGER PROCEDURE FOR FIND OF customer.
MESSAGE "Schema Trigger :: FIND"
VIEW-AS ALERT-BOX INFO BUTTONS OK.
Session Level:
Code:
ON FIND OF customer OVERRIDE
DO:
MESSAGE "Session Trigger :: FIND"
VIEW-AS ALERT-BOX INFO BUTTONS OK.
END.
FOR EACH customer exclusive-lock:
UPDATE custnum NAME.
END.