User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 xiii
Display Dependencies.......................................................................13-16
Change the Name..........................................................................................13-17
Save the View............................................................................................... 13-17
Managing Help Text..........................................................................13-17
Choose the View...........................................................................................13-18
Choose the Column.......................................................................................13-19
Add, Change, or Delete Help Text ................................................................13-19
Save the Help Text .......................................................................................13-20
Managing View Comments ...............................................................13-20
Choose the View...........................................................................................13-21
Add, Change, or Delete Comment.................................................................13-21
Save the View Comment...............................................................................13-22
Managing Column Comments............................................................13-22
Choose the Columns..................................................................................... 13-23
Add, Change, or Delete Comment.................................................................13-23
Save the Column Comment...........................................................................13-24
Invoking a View................................................................................13-24
Choose a View..............................................................................................13-25
Set Invocation Options..................................................................................13-25
Specify Output-File Attributes.......................................................................13-26
Invoke the View ...........................................................................................13-27
Display the Output........................................................................................ 13-27
CHAPTER 14. MANAGING INDEXES........................................... 14-1
Creating an Index............................................................................... 14-1
Assign Name and Location..............................................................................14-2
Choose the Table ............................................................................................14-2
Assign Index Columns ....................................................................................14-3
Assign File Attributes......................................................................................14-3
Assign Additional Attributes ...........................................................................14-4
Save the Index ................................................................................................14-5
Altering an Index................................................................................ 14-5
Choose an Index.............................................................................................14-6
Display Dependencies .....................................................................................14-6
Change Security..............................................................................................14-6
Change File Attributes ....................................................................................14-6
Partitions ........................................................................................................14-7
Save the Index ................................................................................................14-7
Dropping an Index.............................................................................. 14-8
Choose an Index.............................................................................................14-8
Display Dependencies .....................................................................................14-9
Drop the Index................................................................................................14-9
Renaming an Index............................................................................. 14-9
Choose an Index...........................................................................................14-10