NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-25
ALTER PROGRAM Statement
processes. The CONTINUE statement starts the commit phase, directing SQL to
return control to the user if a retryable error occurs during the phase.
•
The following statement moves the latter portion of an index partition into a new
partition (a one-way split):
ALTER INDEX =XPART_LOC PARTONLY MOVE
FROM KEY "I00" TO =XPART_EUROPE
EXTENT (8,8) SLACK 20;
•
The following statement creates two new partitions of an index and moves data to
them from an existing partition, which it then 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 );
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 the following security-related file attributes:
For more information about other file attributes, see the entry for a specific attribute.
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