Db2 z/OS Trigger Maintenance

These commands might be useful for administering triggers.

List All Triggers in a Database

To list all triggers:

SELECT name  FROM SYSIBM.SYSTRIGGERS 

List the Trigger Definition

To list the trigger definition:

SELECT text FROM SYSIBM.SYSTRIGGERS WHERE NAME = trigger_name

List Trigger Information

To list the trigger information:

SELECT text FROM SYSIBM.SYSTRIGGERS WHERE NAME = trigger_name

To Remove a Trigger

To remove a trigger:

DROP trigger TRIGGERNAME  restrict

To Modify an Existing Trigger

You can't alter a trigger. You must drop it and recreate it.

See DB2 for z/OS SQL Reference.

See DB2 for z/OS Application Programming and SQL Guide.