Triggers Editor (IBM DB2 Z/OS)

From RapidSQL
Jump to: navigation, search

Go Up to IBM DB2 for z/OS Object Editors

The Triggers Editor lets you modify the CREATE TRIGGER statement and manage properties for a trigger.

To edit a trigger

  1. Open an editor on the trigger. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Lets you view the Trigger Timing, Trigger Events, Trigger Type, Object Status, Definer, and Function Path properties.

Comment

For details on using this tab, see Adding a Comment to an object.

Dependencies

For details on using this tab, see Working with Object Dependencies.

Definition

Lets you modify the CREATE TRIGGER body for a trigger.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.