HP NonStop G-Series User Manual

Page 174

Advertising
background image

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005

13-9

Figure 13-8. Catalog and View Pane.

Display Dependencies

Before altering a view, you can analyze the impact of altering it:

•

To display the programs that depend on the table, click tab
Dependent Programs. Programs which would be invalidated by
moving the partition are displayed.

•

To display all objects, including programs, that depend on the table,
click tab Dependent Objects. All SQL objects that depend on the
table are displayed.

Change the Column Heading

To change a column heading in the view, perform the following steps.
Refer to Figure 13-9 for an example of the Column pane in the Alter View
window.

Place the cursor in the Heading field and edit the text.

Figure 13-9. Column Pane in Alter View Window.

Change Security

Assign a security string in the Security pane, as shown in Figure 13-10.
You cannot change a protection view’s group ID or owner ID.

1. Use the drop-down lists in the R, W, E, and P fields in the Security

pane.

Advertising