Owner manual

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