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 or view of the trigger. |
| EVENT_OBJECT_TABLE | TABNAME | VARCHAR(128) | Name of the subject table or view of the trigger. |
| ACTION_ORDER | ORDERSEQNO | INTEGER | The ordinal position of this trigger in the list of triggers for the table or view. This indicates the order in which the trigger will be fired. |
| ACTION_CONDITION | CONDITION | DBCLOB(2097152) CCSID 13488 Nullable |
Text of the WHEN clause for the trigger. Contains the null value if there is no WHEN clause. |
| ACTION_STATEMENT | TEXT | DBCLOB(2097152) CCSID 13488 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(7) | Indicates whether this is a BEFORE,
AFTER, or INSTEAD OF 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. A table or view that has a trigger that contains a reference to that same table or view in its triggered–action is self-referencing. If a self-referencing trigger is duplicated into another library, restored into another library, moved into another library, or renamed; the trigger is marked inoperative since the table references in the triggered–action are unchanged and still reference the original schema and table name.
|
| 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. |
| TRIGGER_DEFINER | DEFINER | VARCHAR(128) | Name of the user that defined the trigger. |
| TRIGGER_TEXT | LABEL | VARGRAPHIC(50) CCSID 1200 Nullable |
A character string provided with
the LABEL statement. Contains the null value if there is no label. |
| LONG_COMMENT | REMARKS | DBCLOB(2000) CCSID 13488 Nullable |
A character string supplied with
the COMMENT statement. Contains the null value if there is no long comment. |
| ROUNDING_MODE | DECFLTRND | CHAR(1) Nullable |
The rounding mode for the trigger:
Contains the null value if the trigger was created via the ADDPFTRG command. |
| SYSTEM_TRIGGER_SCHEMA | SYS_TDNAME | CHAR(10) | System schema name. |
| SYSTEM_EVENT_OBJECT_SCHEMA | SYS_DNAME | CHAR(10) | System schema name of the schema containing the subject table or view of the trigger. |
| SYSTEM_EVENT_OBJECT_TABLE | SYS_TNAME | CHAR(10) | System table name of the table or view that contains the subject table or view of the trigger. |