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.
Related concepts
Getting started with iSeries Navigator SQL programming