The SYSTRIGGERS view contains one row for each trigger in an SQL
schema. The following table describes the columns in the SYSTRIGGERS
view:
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
TRIGGER_SCHEMA | TRIGSCHEMA | VARCHAR(128) | Name of the schema containing the trigger. |
TRIGGER_NAME | TRIGNAME | VARCHAR(128) | Name of the trigger. |
EVENT_MANIPULATION | TRIGEVENT | VARCHAR(6) | Indicates the event that causes the trigger to fire:
|
EVENT_OBJECT_SCHEMA | TABSCHEMA | VARCHAR(128) | Name of the schema containing the subject table of the trigger. |
EVENT_OBJECT_TABLE | TABNAME | VARCHAR(128) | Name of the subject table of the trigger. |
ACTION_ORDER | ORDERSEQNO | INTEGER | The ordinal position this trigger in the list of triggers for the table. This indicates the order in which the trigger will be fired. |
ACTION_CONDITION | CONDITION | DBCLOB(1048576)
Nullable | Text of the WHEN clause for the trigger.
Contains the null value if there is no WHEN clause. |
ACTION_STATEMENT | TEXT | DBCLOB(1048576)
Nullable | Text of the SQL statements in the trigger action.
Contains the null value if this is a trigger created via the ADDPFTRG command. |
ACTION_ORIENTATION | GRANULAR | VARCHAR(9) | Indicates whether this is a ROW or STATEMENT trigger:
|
ACTION_TIMING | TRIGTIME | VARCHAR(6) | Indicates whether this is a BEFORE or AFTER trigger:
|
TRIGGER_MODE | TRIGMODE | VARCHAR(6) | Indicates the firing mode for the trigger:
|
ACTION_REFERENCE_OLD_ROW | OLD_ROW | VARCHAR(128)
Nullable | Name of the OLD ROW correlation name.
Contains the null value if an OLD ROW correlation name was not specified. |
ACTION_REFERENCE_NEW_ROW | NEW_ROW | VARCHAR(128)
Nullable | Name of the NEW ROW correlation name.
Contains the null value if a NEW ROW correlation name was not specified. |
ACTION_REFERENCE_OLD_TABLE | OLD_TABLE | VARCHAR(128)
Nullable | Name of the OLD TABLE correlation name.
Contains the null value if an OLD TABLE correlation name was not specified. |
ACTION_REFERENCE_NEW_TABLE | NEW_TABLE | VARCHAR(128)
Nullable | Name of the NEW TABLE correlation name.
Contains the null value if a NEW TABLE correlation name was not specified. |
SQL_PATH | SQL_PATH | VARCHAR(3483)
Nullable | SQL path used when the trigger was created.
Contains the null value if the trigger was created via the ADDPFTRG command. |
CREATED | CREATE_DTS | TIMESTAMP | Timestamp when the trigger was created. |
TRIGGER_PROGRAM_NAME | TRIGPGM | VARCHAR(128) | Name of the trigger program. |
TRIGGER_PROGRAM_LIBRARY | TRIGPGMLIB | VARCHAR(128) | System name of the schema containing the trigger program. |
OPERATIVE | OPERATIVE | VARCHAR(1) | Indicates whether the trigger is operative (is associated with a file
that has a member).
|
ENABLED | ENABLED | VARCHAR(1) | Indicates whether the trigger is enabled (see the CL command CHGPFTRG)
|
THREADSAFE | THDSAFE | VARCHAR(8) | Indicates whether the trigger is thread safe.
|
MULTITHREADED_JOB_ACTION | MLTTHDACN | VARCHAR(8) | Indicates the action to take when the trigger program is called in a
multithreaded job.
|
ALLOW_REPEATED_CHANGE | ALWREPCHG | VARCHAR(8) | Indicates the condition under which an update event fires the
trigger.
|
TRIGGER_UPDATE_CONDITION | TRGUPDCND | CHAR(8)
Nullable | Indicates whether an UPDATE trigger is always fired on an update event or
only when a column value is actually changed.
Contains the null value if the trigger is not an UPDATE trigger. |
LONG_COMMENT | REMARKS | VARGRAPHIC(2000)
Nullable | A character string supplied with the COMMENT statement.
Contains the null value if there is no long comment. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.