 |
| SYSTRIGDEP Catalog Table for SQL Trigger |
This article contains the SYSTRIGDEP catalog table used for SQL triggers.
SYSTRIGDEP
This view contains the specific information about the trigger in the SQL schema objects referenced in the WHEN clause or the triggered SQL statements of a trigger.
Structure of SYSTRIGDEP
| Column Name | Description |
|---|---|
| TRIGGER_SCHEMA | Name of the schema containing trigger |
| TRIGGER_NAME | Name of the trigger |
| OBJECT_SCHEMA | Schema containing object referenced in the trigger |
| OBJECT_NAME | Name of the object referred |
| OBJECT_TYPE | The object type of the object referenced in the trigger |
| PARM_SIGNATURE | Identifies the routine signature |
| SYSTEM_TRIGGER_SCHEMA | System schema name |
| SYSTEM_OBJECT_SCHEMA | System schema name of the object referenced in the trigger |
| SYSTEM_OBJECT_NAME | System object name referenced in the trigger |
Example
Select * from QSYS2.SYSTRIGDEP
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
- Trigger Limitations and Program Attributes
- Effects On Trigger When New File Field Is Added
- SYSTRIGGERS Catalog Table for SQL Trigger
- SYSTRIGUPD Catalog Table for SQL Trigger
- SYSTRIGCOL Catalog Table for SQL Trigger