6. QUEL and EQUEL Statements : Modify Statement--Change Table or Index Properties : Modify...to Reorganize Option
 
Share this page                  
Modify...to Reorganize Option
To move the data and change the number of locations without changing storage structure, specify reorganize. For example, to spread an employee table over three locations:
modify employee to reorganize 
with location = (area1, area2, area3);
When you specify reorganize, the only valid with clause option is location.