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