Removing triggers

 

You can remove triggers using the Remove Physical File Trigger (RMVPFTRG) command, the SQL DROP TRIGGER statement, and iSeries™ Navigator.

Use the RMVPFTRG command to remove the association of a file and the trigger program. After you remove the association, the system takes no action when a change or read operation occurs to the physical file. The trigger program, however, remains on the system.

 

Parent topic:

Triggering automatic events in your database

Related concepts
Getting started with iSeries Navigator SQL programming

Related reference
Remove Physical File Trigger (RMVPFTRG) command