Triggers
Go Up to Supported Objects
Triggers are a special type of procedure that automatically fire when defined data modification operations (insert, update, or delete) occur on a target table or view. Trigger support differs by DBMS type, but in general offers options such as:
- Standard INSERT/DELETE/UPDATE event support
- BEFORE/AFTER timing control
- Row/statement trigger type control
- INSTEAD OF triggers
- Compound triggers
- Enabled/disabled status options
Creating and editing
- Triggers Wizard (DB2 LUW) and Triggers Editor (IBM DB2 LUW)
- Triggers Wizard (DB2 Z/OS) and Triggers Editor (IBM DB2 Z/OS)
- Triggers Wizard (Oracle) and Triggers Editor (Oracle)
- Triggers Wizard (PostgreSQL) and Triggers Editor (PostgreSQL)
- Triggers Wizard (SQL Server) and Triggers Editor (SQL Server)
- Triggers Wizard (Sybase ASE) and Triggers Editor (Sybase ASE)
- Note: Creation and editing of objects of this type is not supported against Sybase IQ datasources.
DBMS platform availability and object actions/operations supported
The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.
DB2 LUW | DB2 z/OS | ORCL | PSTGRS * | SQL SVR | SYB ASE | |
---|---|---|---|---|---|---|
✓ |
✓ | |||||
✓ |
||||||
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ | ||||||
✓ |
✓ |
✓ |
✓ |
✓ | ||
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ |