HP Neoview Release 2.5 Software - Manual (Page 91)

• 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).
Usage Tab
To display the trigger usage information:
1. Select a Schema in the navigation tree and click the table name in the right pane, and then
open the Triggers folder and select a trigger in the tree.
2. Click the Usage tab in the right pane.
In the right pane, these attributes are displayed:
•
Relationship: Specifies the relationship between this trigger and the object.
• Related Object Type: Specifies the object type of the object.
• Related Object Name: Specifies the object name with a hyperlink to the object.
• Creation Time: Time and date when the related object was created. Timestamp is in
the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Redefinition Time:Time and date when the related object was last redefined. Timestamp
is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Operation: Specifies what types of the operation performed on this object to activate
the trigger. The value is one of the (Delete/Insert/Select/Update/Call).
• Is Subject Table: Specifies whether the target is a subject table. The value is “True” or
“False.”
DDL Tab
To display the DDL output for the trigger:
1. Select a Schema in the navigation tree.
2. Click the table name in the right pane, and then open the Triggers folder and select a trigger
in the tree.
3. Click the DDL tab in the right pane.
The DDL tab displays DDL output from the SHOWDDL command in the right pane. You
can highlight and copy contents, but you cannot edit the contents. For more information
about the format of the SHOWDDL command, see the Neoview SQL Reference Manual.
For more information about displaying DDL, see “Display Schema DDL and Their Properties”
(page 91) .
Display Schema DDL and Their Properties
To display schema DDL information, a DDL tab appears in the right pane when these objects
are selected in the navigation tree:
• Schema
• Table
• Table Index
• View
• Materialized View
• Materialized View Index
• Materialized View Group
• Procedure
Display Schema DDL and Their Properties 91