SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-87
Examples of MODIFY
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;
•
Modify table with an online operation
MODIFY TABLE MODT408A05 ADD PARTITION
WHERE KEY= first key upto key= value (30000)
TO LOCATION $data04
WITH SHARED ACCESS
COMMIT BEFORE '2007-04-05 16:25:40'
ONCOMMITERROR COMMIT WORK AFTER '2007-04-05 25:19:00';