SYSTRIGGERS

The SYSTRIGGERS view contains one row for each trigger in an SQL schema. The following table describes the columns in the SYSTRIGGERS view:

Table 136. 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:
DELETE
Trigger fires on a DELETE.
INSERT
Trigger fires on a INSERT.
UPDATE
Trigger fires on a DELETE.
READ
Trigger fires when a row is read. This is only valid for triggers created via the ADDPFTRG command.
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:
ROW
Trigger fires for each ROW.
STATEMENT
Trigger fires for each statement.
ACTION_TIMING TRIGTIME VARCHAR(7) Indicates whether this is a BEFORE, AFTER, or INSTEAD OF trigger:
BEFORE
Trigger fires before the triggering event.
AFTER
Trigger fires after the triggering event.
INSTEAD
Trigger fires instead of the triggering event.
TRIGGER_MODE TRIGMODE VARCHAR(6) Indicates the firing mode for the trigger:
DB2SQL
The trigger mode is DB2SQL.
DB2ROW
The trigger mode is DB2ROW.
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.

Y
The trigger is operative.
N
The trigger is inoperative.
ENABLED ENABLED VARCHAR(1) Indicates whether the trigger is enabled (see the CL command CHGPFTRG)
Y
The trigger is enabled.
N
The trigger is disabled.
THREADSAFE THDSAFE VARCHAR(8) Indicates whether the trigger is thread safe.
YES
The trigger is thread safe.
NO
The trigger is not thread safe.
UNKNOWN
The thread safety of the trigger is unknown.
MULTITHREADED_JOB_ACTION MLTTHDACN VARCHAR(8) Indicates the action to take when the trigger program is called in a multithreaded job.
SYSVAL
Use the QMLTTHDACN system value to determine the action to take.
MSG
Run the trigger program in a multithreaded job, but send a diagnostic message.
NORUN
Do not run the trigger program in a multithreaded job.
RUN
Run the trigger program in a multithreaded job.
ALLOW_REPEATED_CHANGE ALWREPCHG VARCHAR(8) Indicates the condition under which an update event fires the trigger.
YES
The trigger allows repeated changes to the same row.
NO
The trigger does not allow repeated changes to the same row.
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.
ALWAYS
The trigger is always fired on an update event.
CHANGE
The trigger is only fired on an update event if 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.