SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-62
Examples of MODIFY
Examples of MODIFY
•
Move all records of an existing range partition to a new location:
MODIFY TABLE tab1 MOVE PARTITION
WHERE LOCATION $data02
TO LOCATION $data03;
•
Move records of an existing range partition, whose key is equal to 10000 to the last
key, to a new location:
MODIFY TABLE tab1 MOVE PARTITION
WHERE KEY = VALUE (10000) THRU KEY = LAST KEY
TO LOCATION $data02
EXTENT (512, 512) MAXEXTENTS 256;
•
Move the second partition of a hash partitioned table to a new location:
MODIFY TABLE tab1 MOVE PARTITION
WHERE KEY = VALUE (2)
TO LOCATION $DATA02;
•
Move a partition of a hash partitioned table from $data02 to $data03:
MODIFY TABLE tab1 MOVE PARTITION
WHERE LOCATION $data02
TO LOCATION $data03
EXTENT (1024, 1024) MAXEXTENTS 256;