Displaying Triggers

When you select the triGgers option from the INFO menu, the INFO FOR TRIGGER screen appears, as Figure 104 shows.

INFO FOR TRIGGER>>
Choose a trigger with the Arrow Keys, or enter a name, then press Return.

------------------mydata@mydbserv--------------- Press CTRL-W for Help ------

 updrec_t 

Select a trigger from the list of trigger names in the current table. If you do not want to select a trigger, press the Interrupt key, and you return to the TABLE INFO menu.

If the header and body information for the selected trigger fit on one screen, the INFO menu reappears, displaying the trigger information, as Figure 105 shows.

INFO - updrec_t:  ....  triGgers   Status  Table  Exit
Display header and body information for a trigger.

----------------- mystores@dbserver1 ----------- Press CTRL-W for Help ------

create trigger updrec_t 
                unit_price on stock
                        referencing old as pre_upd
                                new as post_upd

        (insert into log_record values (stock_num, CURRENT,
        pre_upd.unit_price, post_upd.unit_price)) for each row;

Figure 105 shows the header information for a trigger, which consists of the CREATE TRIGGER statement and trigger name, the SQL statement that triggers an event, and the referencing clause. The body of a trigger is the triggered action. In Figure 105, the triggered action is the INSERT statement.

If the trigger does not fit on a single INFO menu screen, use the menu at the top of the screen as follows:

• Press N, or if the Next option is highlighted, press RETURN to advance to the next screen of trigger information. Continue to press N or RETURN as needed to page through the information.
• Select Restart at any time to display the trigger information from the beginning.
• Select Exit to return to the TABLE menu.