 |
| SYSTRIGGERS Catalog Table for SQL Trigger |
This article contains the SYSTRIGGERS catalog table used for SQL triggers.
SYSTRIGGERS
This view contains the specific information about the trigger in SQL schema
Structure of SYSTRIGGERS
| Column Name | Description |
|---|---|
| TRIGGER_SCHEMA | Name of the schema containing trigger |
| TRIGGER_NAME | Name of the trigger. |
| EVENT_MANIPULATION | INSERT/DELETE/UPDATE/READ/MULTI |
| EVENT_OBJECT_SCHEMA | Schema name containing table or view of the trigger |
| EVENT_OBJECT_TABLE | Name of the table or view of the trigger |
| ACTION_ORDER | Indicates the order in which the trigger will be fired. |
| ACTION_CONDITION | WHEN clause / NULL value if no WHEN clause |
| ACTION_STATEMENT | SQL statement text |
| ACTION_ORIENTATION | Trigger activated at each ROW/STATEMENT |
| ACTION_TIMING | BEFORE/AFTER/INSTEAD |
| TRIGGER_MODE | DB2ROW / DB2SQL |
| ACTION_REFERENCE_OLD_ROW | Name of Old Row |
| ACTION_REFERENCE_NEW_ROW | Name of New Row |
| ACTION_REFERENCE_OLD_TABLE | Name of Old Table |
| ACTION_REFERENCE_NEW_TABLE | Name of New Table |
| SQL_PATH | SQL path was used when the trigger was created. |
| CREATED | Timestamp |
| TRIGGER_PROGRAM_NAME | Trigger program |
| TRIGGER_PROGRAM_LIBRARY | Trigger program library |
| OPERATIVE | The trigger is operative or not (Y/N) |
| ENABLED | The trigger is enabled or not (Y/N) |
| THREADSAFE | The trigger is thread-safe or not (Yes/No/Unknown) |
| MULTITHREADED_JOB_ACTION | SYSVAL / MSG / NORUN / RUN |
| ALLOW_REPEATED_CHANGE | Update event condition |
| TRIGGER_UPDATE_CONDITION | ALWAYS / CHANGE |
| TRIGGER_DEFINER | Name of the user that defined the trigger. |
| TRIGGER_TEXT | Lable statement |
| LONG_COMMENT | Comment statement |
| ROUNDING_MODE | C/D/F/G/E/H/U |
| SYSTEM_TRIGGER_SCHEMA | System schema name. |
| SYSTEM_EVENT_OBJECT_SCHEMA | System schema name containing table or view |
| SYSTEM_EVENT_OBJECT_TABLE | System table or view name |
| EVENTUPDATE | Update event fired (Y/N) |
| EVENTINSERT | Insert event fired (Y/N) |
| EVENTDELETE | Delete event fired (Y/N) |
Example
Select * from QSYS2.SYSTRIGGERS
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
- SYSTRIGDEP Catalog Table for SQL Trigger
- SYSTRIGUPD Catalog Table for SQL Trigger
- SYSTRIGCOL Catalog Table for SQL Trigger