HP Integrity NonStop H-Series - Manual (Page 13)

dba/m Database Manager V7.1 User's Guide – 540156-001 xiii
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