SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-27
ALTER PROGRAM Statement

This example creates two new partitions of an index and moves data to them from
an existing partition, which it deletes (a two-way split):
ALTER INDEX $DISK1.SALES.XORDERS PARTONLY MOVE
( FROM FIRST KEY UP TO KEY 50 TO $DISK2 CATALOG =CAT2,
FROM KEY 50 UP TO LAST KEY TO $DISK3 CATALOG =CAT3 );

This example moves the latter portion of an index partition into a new partition (a
one-way split) in which the new partition is Format 2:
ALTER INDEX =XPART_LOC PARTONLY MOVE
FROM KEY "I00" TO =XPART_EUROPE
EXTENT (8,8) SLACK 20 FORMAT 2;
ALTER PROGRAM Statement
ALTER PROGRAM is a DDL statement that renames an SQL program in a Guardian
file or alters security-related file attributes for an SQL program in a Guardian file. (You
cannot use ALTER PROGRAM on an SQL program in an OSS file.)
program
is the name of a file (or an equivalent DEFINE) that contains an SQL-compiled
SQL program in a Guardian file.
security-spec
sets these security-related file attributes:
For more information, see the entry for a specific attribute.
RENAME new-name
renames the program and changes all references to the old name in the affected
catalog to the new name; new-name is a Guardian name or DEFINE. The fully
ALTER PROGRAM program { security-spec }
{ RENAME new-name }
security-spec is:
{| [NO]CLEARONPURGE |}
{| SECURE "rwep" |}
{| OWNER group-num,user-num [ NO PROGID ] |}
{| { PROGID | NO PROGID } |}
CLEARONPURGE Controls disk erasure when file is dropped
SECURE Sets Guardian security string
OWNER Specifies owner
PROGID Determines PAID of process from file