SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-297
Examples of MODIFY
•
Renaming a set of specified locations of an index
MODIFY INDEX CAT.SCH.IDX2
RENAME LOCATION
( $DATA01.ZSDABCDE.ABCDEF00 TO FEDCBA00
, $DATA02.ZSDABCDE.GHIJKL00 TO LKJIHG00 );
•
Renaming all locations matching a pattern of a filename of an index
MODIFY INDEX CAT.SCH.MYIX
RENAME WHERE LOCATION $DATA*.ZSDXYZZY.S* TO T?????00;
In the example, the mapping specification T?????00 indicates that the initial
character of the target file name must be 'T', regardless of the character in the
source file name. The subsequent five characters will be copied from the
corresponding positions in the source file name and the last two will be 00.
•
This example moves the partition of a sequence generator:
MODIFY SEQUENCE seq1 MOVE PARTITION TO LOCATION $data02;
•
This example renames the Guardian location of a sequence generator:
MODIFY SEQUENCE seq1 RENAME WHERE LOCATION $DATA06.ZSD
GQJL7.GGLP9700 to NEWLOC00;
•
This example uses a pattern to rename the Guardian location of a sequence
generator:
MODIFY SEQUENCE seq1 RENAME WHERE LOCATION $*.*.* MAP NAMES
TO NW????00;
•
Renaming a single Guardian location of an index
MODIFY INDEX CAT.SCH.IDX1
RENAME WHERE LOCATION
$DATA01.ZSDABCDE.SPARTN00 TO TPARTN00;
Note that the keyword WHERE is optional.