HP NonStop G-Series User Manual

Page 17

Advertising
background image

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005

xv

Drop Partitions ..................................................................................16-11

Choose Partition: .......................................................................................... 16-12
Display Dependencies ................................................................................... 16-12
Drop the Partitions........................................................................................ 16-13

Perform a Simple Move.....................................................................16-13

Choose a Index ............................................................................................. 16-14
Select the Partition........................................................................................ 16-14
Assign Name and Location............................................................................ 16-14
Assign File Attributes.................................................................................... 16-14
Display Dependencies ................................................................................... 16-15
Move the Partition ........................................................................................ 16-15

Performing a One-Way Split..............................................................16-15

Choose Index................................................................................................ 16-16
Assign Name and Location............................................................................ 16-16
Assign File Format ........................................................................................ 16-17
Assign File Attributes.................................................................................... 16-17
Display Dependencies ................................................................................... 16-17
Move the Partition ........................................................................................ 16-18

Performing a Two-Way Split .............................................................16-18

Choose Index................................................................................................ 16-19
Assign Names and Locations......................................................................... 16-19
Assign File Attributes.................................................................................... 16-19
Assign Primary-Key Values........................................................................... 16-20
Display Dependencies ................................................................................... 16-20
Move the Partition ........................................................................................ 16-20

CHAPTER 17. MANAGING PROGRAMS ..................................... 17-1

Altering a Program ............................................................................. 17-1

Choose a Program .......................................................................................... 17-2
Change the Security ........................................................................................ 17-2
Save the Program............................................................................................ 17-3

Dropping a Program ........................................................................... 17-3

Choose a Program .......................................................................................... 17-4
Drop the Program........................................................................................... 17-4

Compiling a Program.......................................................................... 17-4

Compiling Old Programs................................................................................. 17-5
Compiling New Programs ............................................................................... 17-7

Copy or Move Programs ...................................................................17-10

Choose Programs.......................................................................................... 17-11
Define the Target Location ........................................................................... 17-12
Choose the Copy or Move Operation............................................................ 17-12
Choose Compiler Options ............................................................................. 17-12
Assign Catalog.............................................................................................. 17-13
Perform the Copy or Move ........................................................................... 17-13

Advertising