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 | |
|---|---|---|---|---|---|---|
|
✓ |
✓ | |||||
|
✓ |
||||||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
|
✓ | ||||||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
|
✓ |