Owner manual

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