HP NonStop G-Series - Manual (Page 15)

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