DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.TRIGGERS catalog view

Each row represents a trigger. For table hierarchies, each trigger is recorded only at the level of the hierarchy where the trigger was created.

Table 1. SYSCAT.TRIGGERS Catalog View
Column Name Data Type Nullable Description
TRIGSCHEMA VARCHAR (128)   Schema name of the trigger.
TRIGNAME VARCHAR (128)   Unqualified name of the trigger.
OWNER VARCHAR (128)   Authorization ID of the owner of the trigger.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
TABSCHEMA VARCHAR (128)   Schema name of the table or view to which this trigger applies.
TABNAME VARCHAR (128)   Unqualified name of the table or view to which this trigger applies.
TRIGTIME CHAR (1)   Time at which triggered actions are applied to the base table, relative to the event that fired the trigger.
  • A = Trigger is applied after the event
  • B = Trigger is applied before the event
  • I = Trigger is applied instead of the event
TRIGEVENT CHAR (1)   Event that fires the trigger.
  • D = Delete event
  • I = Insert event
  • M = Multiple events
  • U = Update event
GRANULARITY CHAR (1)   Trigger is executed once per:
  • R = Row
  • S = Statement
VALID CHAR (1)  
  • N = Trigger is invalid
  • X = Trigger is inoperative and must be recreated
  • Y = Trigger is valid
CREATE_TIME TIMESTAMP   Time at which the trigger was defined. Used in resolving functions and types.
QUALIFIER VARCHAR (128)   Value of the default schema at the time of object definition. Used to complete any unqualified references.
FUNC_PATH CLOB (2K)   SQL path in effect when the trigger was defined.
TEXT CLOB (2M)   Full text of the CREATE TRIGGER statement, exactly as typed.
LAST_REGEN_TIME TIMESTAMP   Time at which the packed descriptor for the trigger was last regenerated.
COLLATIONSCHEMA VARCHAR (128)   Schema name of the collation for the trigger.
COLLATIONNAME VARCHAR (128)   Unqualified name of the collation for the trigger.
COLLATIONSCHEMA_ORDERBY VARCHAR (128)   Schema name of the collation for ORDER BY clauses in the trigger.
COLLATIONNAME_ORDERBY VARCHAR (128)   Unqualified name of the collation for ORDER BY clauses in the trigger.
PRECOMPILE_OPTIONS VARCHAR (1024)   The precompile and bind options that were in effect when the compiled trigger was created. The null value if the trigger is not compiled.
COMPILE_OPTIONS VARCHAR (1024)   The value of the SQL_CCFLAGS special register that was in effect when the compiled trigger was created and inquiry directives were present. An empty string if no inquiry directives were present in the compiled trigger. The null value if the trigger is not compiled.
DEFINER1 VARCHAR (128)   Authorization ID of the owner of the trigger.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.
Note:
  1. The DEFINER column is included for backwards compatibility. See OWNER.