DB2 Universal Database for iSeries SQL Reference

SYSTRIGUPD

The SYSTRIGUPD view contains one row for each column identified in the UPDATE column list, if any. The following table describes the columns in the SYSTRIGUPD view:

Table 132. SYSTRIGUPD 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_OBJECT_SCHEMA TABSCHEMA VARCHAR(128) Name of the schema containing the subject table of the trigger.
EVENT_OBJECT_TABLE TABNAME VARCHAR(128) Name of the subject table of the trigger.
TRIGGERED_UPDATE_COLUMNS TABCOLUMN VARCHAR(128) Name of a column specified in the UPDATE column list of the trigger.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]