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 1. 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 UPDATE.
READ
Trigger fires when a row is read. This is only valid for triggers created via the ADDPFTRG command.
Start of changeMULTIEnd of change
Start of changeTrigger fires for multiple events. The EVENTUPDATE, EVENTDELETE, and EVENTINSERT columns define the events.End of change
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 clauseStart of change or if this is an obfuscated triggerEnd of change.
ACTION_STATEMENT TEXT DBCLOB(2097152) CCSID 13488
Nullable
 Text of the SQL statements in the trigger action.

Start of changeIf this is an obfuscated trigger, the text starts with the WRAPPED keyword and is followed by the encoded form of the statement text.End of change

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.
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.
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:
C
ROUND_CEILING
D
ROUND_DOWN
F
ROUND_FLOOR
G
ROUND_HALF_DOWN
E
ROUND_HALF_EVEN
H
ROUND_HALF_UP
U
ROUND_UP

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.
Start of changeSECUREEnd of change Start of changeSECUREEnd of change Start of changeCHAR(1)End of change Start of changeIndicates whether the trigger is considered secure for row access control and column access control.
N
The trigger is not considered secure for row access control and column access control.
Y
The trigger is considered secure for row access control and column access control.
End of change
Start of changeLAST_ALTEREDEnd of change Start of changeALTEREDTSEnd of change Start of changeTIMESTAMP
Nullable
End of change		 Start of changeTimestamp when the trigger was last altered. Contains the null value if the trigger has never been altered.End of change
Start of changeEVENTUPDATEEnd of change Start of changeEVENT_UEnd of change Start of changeCHAR(1)End of change Start of changeIndicates whether an update event fires this trigger.
Y
Yes
N
No
End of change
Start of changeEVENTINSERTEnd of change Start of changeEVENT_IEnd of change Start of changeCHAR(1)End of change Start of changeIndicates whether an insert event fires this trigger.
Y
Yes
N
No
End of change
Start of changeEVENTDELETEEnd of change Start of changeEVENT_DEnd of change Start of changeCHAR(1)End of change Start of changeIndicates whether a delete event fires this trigger.
Y
Yes
N
No
End of change