6. QUEL and EQUEL Statements : Relocate Statement--Relocate Tables : Description
 
Share this page                  
Description
The relocate statement moves a table from its current location to the location specified by locationname. You cannot relocate a table that exists on multiple locations—you must use the modify statement to move it. Relocate takes an exclusive table lock. Other sessions cannot access the table until the relocation is complete.