 |
| SYSTRIGUPD Catalog Table for SQL Trigger |
This article contains the SYSTRIGUPD catalog table used for SQL triggers.
SYSTRIGUPD
This view contains the specific information about each column identified in the UPDATE column list
Structure of SYSTRIGUPD
| Column Name | Description |
|---|---|
| TRIGGER_SCHEMA | Name of the schema containing trigger |
| TRIGGER_NAME | Name of the trigger |
| EVENT_OBJECT_SCHEMA | Schema name containing the table of the trigger |
| EVENT_OBJECT_TABLE | Name of the table |
| TRIGGERED_UPDATE_COLUMNS | Column specified in the UPDATE column list |
| SYSTEM_TRIGGER_SCHEMA | System schema name |
| SYSTEM_EVENT_OBJECT_SCHEMA | System schema name containing the table or view |
| SYSTEM_EVENT_OBJECT_TABLE | System table name of the table or view |
Example
Select * from QSYS2.SYSTRIGUPD
Result
Related Post
Read also :
- SQL Triggers concept in IBM i DB2
- Syntax for Create Trigger in IBM i AS400
- Simple SQL Trigger Example
- Conditional SQL Trigger Example
- OF Clause in SQL Trigger
- Multiple Event Execution Through SQL Trigger
- Change Row Before Inserting In Table (Before SQL Trigger)
- Stored Procedure calling in SQL Trigger
- Transition Tables in SQL Triggers
- Error Handling in SQL Trigger Using Signalling
- Self Referencing SQL trigger
- INSTEAD OF SQL Trigger (Adding / Deleting / Inserting record in the table through SQL View)
- Trigger Limitations and Program Attributes
- Effects On Trigger When New File Field Is Added
- SYSTRIGGERS Catalog Table for SQL Trigger
- SYSTRIGDEP Catalog Table for SQL Trigger
- SYSTRIGCOL Catalog Table for SQL Trigger