SYSTRIGGERS
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 or if this is an obfuscated trigger. |
ACTION_STATEMENT | TEXT | DBCLOB(2097152) CCSID 13488 Nullable
|
Text of the SQL statements in the
trigger action. If this is an obfuscated trigger, the text starts with the WRAPPED keyword and is followed by the encoded form of the statement text. 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.
|
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 | VARGRAPHIC(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. |
SECURE | SECURE | CHAR(1) | Indicates whether the trigger is
considered secure for row access control and column access control.
|
LAST_ALTERED | ALTEREDTS | TIMESTAMP Nullable
|
Timestamp when the trigger was last altered. Contains the null value if the trigger has never been altered. |
EVENTUPDATE | EVENT_U | CHAR(1) | Indicates whether an update event
fires this trigger.
|
EVENTINSERT | EVENT_I | CHAR(1) | Indicates whether an insert event
fires this trigger.
|
EVENTDELETE | EVENT_D | CHAR(1) | Indicates whether a delete event
fires this trigger.
|