Renaming a view – HP NonStop G-Series User Manual

Page 180

Advertising
background image

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

13-15

To display the programs that depend on the script, click on
Dependent Programs. Programs that would be invalidated by
the change are displayed.

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

Create New View

You may edit the script shown to create a new view.

Save New View

After you have defined the new view, click on one of the following:

Execute. Executes the command immediately.

Show. Displays the SQL commands created by dba/m Database
Manager without executing them.

Queue. Queues the command to be submitted in a batch later.

Renaming a View

Use the Rename window to change the name of a view. You can also
analyze the impact of changing the view’s name by displaying the objects
that depend on the view.

To display the Rename window, click on Views in the Main window, then
click on Rename. The Rename View window is displayed, as shown in
Figure 13-15.

Advertising