HP Neoview Release 2.5 Software - Manual (Page 84)

Attributes Tab
To display the materialized view groups attributes:
1. Select a Schema in the navigation tree.
2. Click the Materialized View Groups tab in the right pane, or open the Materialized View
Groups folder and select a materialized view group name in the tree.
3. Click the Attributes tab in the right pane.
In the right pane, these attributes are displayed:
•
Name: Name of the materialized view group.
• Creation Time: Time and date when the materialized view was created. Timestamp is
in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Redefinition Time: Time and date when the materialized view was last redefined.
Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
Members Tab
To display the names of the members of the materialized view group:
1. Select a Schema in the navigation tree.
2. Click the Materialized View Groups tab in the right pane, or open the Materialized View
Groups folder and select a materialized view group name in the tree.
3. Click the Members tab in the right pane.
In the right pane, the members are displayed in a table with the following attributes:
•
Name: Name of the materialized view. The object names are 2-part ANSI names.
• Creation Time: Time and date when the materialized view was created. Timestamp is
in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Redefinition Time: Time and date when the materialized view was last redefined.
Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
DDL Tab
To display the DDL output for materialized view groups:
1. Select a Schema in the navigation tree.
2. Click the Materialized View Groups tab in the right pane, or open the Materialized View
Groups folder and select a materialized view group name 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 Procedures and Their Properties
To display the procedures in a schema:
1. Start the HP Database Manager and log on using any user ID.
2. Click the Database area.
3. In the navigation tree pane, select a Schema, and expand the schema so that you can see
the object folders underneath it.
4. Expand the Procedures folder, and select a procedure.
84 Display Database Objects