HP NonStop G-Series - Manual (Page 13)

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