Was this helpful?
RELOCATE--Relocate Tables
Valid in: QUEL, EQUEL
Relocates tables.
This statement has the following format:
[##] relocate tablename to locationname
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.
Last modified date: 11/28/2023