Column name
|
Data type
|
Description
|
TRIGGER_SYSID
|
INTEGER
|
System identifier of the trigger. |
EVENT_TABLE_SYSID
|
INTEGER
|
System identifier of the table on which the trigger is defined. |
EVENT_MANIPULATION
|
CHAR(20)
|
One of:
"DELETE"
"INSERT"
"UPDATE". |
ACTION_ORDER
|
INTEGER
|
Ordinal number for trigger execution. This number will define the execution order of triggers on the same table and with the same value for EVENT_MANIPULATION, ACTION_CONDITION, CONDITION_TIMING and ACTION_ORIENTATION. The trigger with 1 in this column will be executed first, followed by the trigger with 2 etc. |
ACTION_CONDITION
|
VARCHAR(2000)
|
The text of the search condition of the trigger action WHEN clause. |
ACTION_STATEMENT
|
VARCHAR(2000)
|
The character representation of the body of the trigger. If the length of the text exceeds 2000 characters, the NULL value will be shown. |
ACTION_ORIENTATION
|
CHAR(20)
|
One of:
"ROW"
"STATEMENT". |
CONDITION_TIMING
|
CHAR(20)
|
One of:
"BEFORE"
"AFTER"
"INSTEAD OF". |
COND_REF_NEW_TABLE
|
VARCHAR(128)
|
Name of new table/row alias. |
COND_REF_OLD_TABLE
|
VARCHAR(128)
|
Name of old table/row alias. |
REFERENCE_NEW
|
CHAR(3)
|
One of:
"NO" = The trigger has no new table/row alias
"YES" = The trigger has new table/row alias. |
REFERENCE_OLD
|
CHAR(3)
|
One of:
"NO" = The trigger has no new table/row alias
"YES" = The trigger has new table/row alias. |
COLS_IS_IMPLICIT
|
CHAR(3)
|
One of:
"NO" = The trigger is invoked on update on any column (if the event is update)
"YES" = The trigger will only be invoked if a column in the for update of list is updated. |
REF_SYSID
|
INTEGER
|
System identifier for foreign key constraint, if the trigger is defined for checking of a delete rule. |
