beautypg.com

Attributes tab – HP Neoview Release 2.4 Software User Manual

Page 72

background image

In the right pane, these tabs appear:

Attributes tab

Usage tab

DDL tab

Attributes Tab

To display the trigger attributes:

1.

Select a Schema in the navigation tree.

2.

Click the table name in the right pane, or open the Tables folder and then open the Triggers
folder and select a trigger in the tree.

3.

Click the Attributes tab in the right pane.

In the right pane, these attributes are displayed:

Name: Name of the trigger.

Is Enabled: Specifies if the trigger is enabled. The value is “'Yes” or “'No.”

Activation Time: Specifies when the trigger is activated. Used in combination with an
operation. The value is “Before” or “After.”

Operation: Specifies operation that causes the trigger to be activated. The values are
(Insert | Delete | Update).

Granularity: Specifies “Row” or “Statement” trigger. Row triggers are allowed for all
Time/Event combinations. Statement triggers are allowed AFTER events. For more
information, see the Neoview SQL Reference Manual.

Creation Time: Time and date when the trigger was created. Timestamp is in the format
(yyyy-MM-dd HH:mm:ss.FFFFFF local time).

Redefinition Time: Time and date when the trigger was last redefined. Timestamp is
in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).

72

Manage Database Objects