m 6.1+)

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

Managing Table Statistics..................................................................12-30

Choose the Tables.........................................................................................12-31

Display the Statistics..................................................................................... 12-31

Display Dependencies ................................................................................... 12-33

Update the Statistics ..................................................................................... 12-33

Invoking a Table ...............................................................................12-35

Choose a Table .............................................................................................12-36

Set Invoke Options.......................................................................................12-36

Specify Output-File Attributes.......................................................................12-37

Invoke the Table...........................................................................................12-38

Display the Output........................................................................................ 12-38

Recreating Tables .........................................................................................12-40

CHAPTER 13. MANAGING VIEWS............................................... 13-1

Creating a View ................................................................................. 13-2

Assign Name and Location..............................................................................13-2

Choose the Type of View................................................................................13-3

Assign a Security ............................................................................................13-3

Choose a Base Table.......................................................................................13-4

Display Indexes on Base Tables ......................................................................13-5

Add Columns..................................................................................................13-5

Delete Columns ..............................................................................................13-6

Insert Columns................................................................................................13-6

Change Column Attributes..............................................................................13-6

Add, Change, or Delete a WHERE Clause......................................................13-7

Save the View.................................................................................................13-7

Altering a View.................................................................................. 13-8

Choose the View.............................................................................................13-8

Display Dependencies .....................................................................................13-9

Change the Column Heading...........................................................................13-9

Change Security..............................................................................................13-9

Change Similarity Check ............................................................................... 13-10

Save the View............................................................................................... 13-10

Dropping a View...............................................................................13-10

Choose the View...........................................................................................13-11

Display Dependencies ................................................................................... 13-11

Drop the View..............................................................................................13-12

Invoke View......................................................................................13-12

Choose the View...........................................................................................13-12

Recreate the View.............................................................................13-13

Create Like .......................................................................................13-14

Choose the View...........................................................................................13-14

Display Dependencies ................................................................................... 13-14

Create New View .........................................................................................13-15