Administration Guide

SYSCAT.TRIGGERS

Contains one row for each trigger. For table hierarchies, each trigger is recorded only at the level of the hierarchy where it was created.

Table 116. SYSCAT.TRIGGERS Catalog View

Column Name Data Type Nullable Description
TRIGSCHEMA VARCHAR(128)
Qualified name of the trigger.
TRIGNAME VARCHAR(18)
DEFINER VARCHAR(128)
Authorization ID under which the trigger was defined.
TABSCHEMA VARCHAR(128)
Qualified name of the table to which this trigger applies.
TABNAME VARCHAR(128)
TRIGTIME CHAR(1)
Time when triggered actions are applied to the base table, relative to the event that fired the trigger:

A = Trigger applied after event
B = Trigger applied before event

TRIGEVENT CHAR(1)
Event that fires the trigger.

I = Insert
D = Delete
U = Update

GRANULARITY CHAR(1)
Trigger is executed once per:

S = Statement
R = Row

VALID CHAR(1)

Y = Trigger is valid
X = Trigger is inoperative; must be re-created.

CREATE_TIME TIMESTAMP
Time at which the trigger was defined. Used in resolving functions and types.
QUALIFIER VARCHAR(128)
Contains value of the default schema at the time of object definition.
FUNC_PATH VARCHAR(254)
Function path at the time the trigger was defined. Used in resolving functions and types.
TEXT CLOB(64K)
The full text of the CREATE TRIGGER statement, exactly as typed.
REMARKS VARCHAR(254) Yes User-supplied comment, or null.

Column Name	Data Type	Nullable	Description
TRIGSCHEMA	VARCHAR(128)		Qualified name of the trigger.
TRIGNAME	VARCHAR(18)
DEFINER	VARCHAR(128)		Authorization ID under which the trigger was defined.
TABSCHEMA	VARCHAR(128)		Qualified name of the table to which this trigger applies.
TABNAME	VARCHAR(128)
TRIGTIME	CHAR(1)		Time when triggered actions are applied to the base table, relative to the event that fired the trigger: A = Trigger applied after event B = Trigger applied before event
TRIGEVENT	CHAR(1)		Event that fires the trigger. I = Insert D = Delete U = Update
GRANULARITY	CHAR(1)		Trigger is executed once per: S = Statement R = Row
VALID	CHAR(1)		Y = Trigger is valid X = Trigger is inoperative; must be re-created.
CREATE_TIME	TIMESTAMP		Time at which the trigger was defined. Used in resolving functions and types.
QUALIFIER	VARCHAR(128)		Contains value of the default schema at the time of object definition.
FUNC_PATH	VARCHAR(254)		Function path at the time the trigger was defined. Used in resolving functions and types.
TEXT	CLOB(64K)		The full text of the CREATE TRIGGER statement, exactly as typed.
REMARKS	VARCHAR(254)	Yes	User-supplied comment, or null.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]