I have written several SQL Triggers over DB2 files on the AS/400. Now I need to write a CL program to either disable (through CHGPFTRG) or remove (RMVPFTRG) all the triggers. How does disabling a trigger vs. removing the trigger differ other than the removal of the trigger physically deletes the trigger program? Are there any AS/400 commands that will not work on a file if the trigger is just disabled instead of fully removed? I've written regular AS/400 triggers for files as well and when you remove the trigger from the file, it doesn't delete the program, it just removes the trigger from the file. However, SQL triggers don't work that way.

I've looked at some of IBM's redbooks on SQL triggers, but haven't seen a discussion on the actual differences.

Thanks to anyone for your insight.