DB2 10.5 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
EVENTUPDATE CHAR (1)   Indicates whether an update event fires the trigger.
  • N = No
  • Y = Yes
EVENTDELETE CHAR (1)   Indicates whether a delete event fires the trigger.
  • N = No
  • Y = Yes
EVENTINSERT CHAR (1)   Indicates whether an insert event fires the trigger.
  • N = No
  • Y = Yes
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 re-created
  • 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.
DEFINER1 VARCHAR (128)   Authorization ID of the owner of the trigger.
SECURE CHAR (1)   Indicates whether the trigger is secure for row and column access control
  • N = Not secure
  • Y = Secure
ALTER_TIME TIMESTAMP   Time at which the trigger was last altered.
DEBUG_MODE VARCHAR (8)   Indicates whether the trigger can be debugged using the DB2® debugger.
  • DISALLOW = Trigger is not debuggable
  • ALLOW = Trigger is debuggable, and can participate in a client debug session with the DB2 debugger
  • DISABLE = Trigger is not debuggable, and this setting cannot be altered without dropping and re-creating the trigger
  • Blank = Trigger type is not currently supported by the DB2 debugger
ENABLED CHAR (1)   Reserved for future use.
LIB_ID INTEGER Y Internal identifier for compiled SQL triggers. Otherwise, the null value.
PRECOMPILE_OPTIONS VARCHAR(1024) Y 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) Y 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.
ENVSTRINGUNITS VARCHAR (11)   Default string units when the object was created.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.
Note:
  1. The DEFINER column is included for compatibility with earlier versions. See OWNER.