You can view the execution log of the trigger from a terminal by using the SET TRIGGER TRACE statement.
SET TRIGGER TRACE switch [ ; ]
switch:
• ON
• OFF
The following example shows how to execute the TRACE and the loop trigger to view the trigger execution logs. To identify the trace for each condition and action executed when the trigger is called, a message is displayed on the terminal. The following message appears 15 times because the loop trigger is executed until the gold value becomes 0.
SET TRIGGER TRACE ON;
UPDATE participant SET gold =15 WHERE nation_code = 'KOR' AND host_year = 1988;
TRACE: Evaluating condition for trigger "loop".
TRACE: Executing action for trigger "loop".