HP Integrity NonStop J-Series - Manual (Page 62)

7. Within the Triggers folder, select the required Trigger.
In the right pane, the following tabs related to the trigger appear:
•
Attributes
•
Related Objects
•
DDL
Figure 21 (page 62) shows the table trigger properties.
Figure 21 Table trigger properties
Viewing the table trigger attributes
To view the table trigger attributes:
1.
In the navigation tree, select the trigger.
2. In the right pane, click Attributes.
The following attributes and their values appear:
•
Name: — The name of the trigger.
•
Metadata UID: — A unique ID of the trigger.
•
Is Enabled: — The attribute specifies whether the trigger is enabled. The available values
are
Yes and No .
•
Activation Time: — The attribute specifies when the trigger is activated. This value is used
in combination with an operation. The available values are
Before and After .
•
Operation: — The attribute specifies the operation that causes the trigger to be activated.
The available values are
Insert , Delete , and Update .
•
Granularity: — The attribute specifies Row or Statement trigger. Row triggers are allowed
for all Time and Event combinations. Statement triggers are allowed for AFTER events.
For more information, see the HP NonStop SQL/MX Release 3.2 Reference Manual.
•
Creation Time: — The time and date when the trigger was created. The time and date
are expressed in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
•
Redefinition Time: — The time and date when the trigger was last redefined. The time
and date are expressed in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
Viewing information on related objects
To view information on related objects:
1.
In the navigation tree, select the trigger.
62 Viewing database objects