Exchange Data With Clone
Go Up to [[Available object actions by DBMS{{#if:||{{{2}}}}}]]
This action lets you issue an EXCHANGE statement with the DATA BETWEEN TABLE table1 AND table2 syntax, letting you swap data between a base table and its clone. To determine whether a table has a clone, see the Dependencies tab/panel on a Table editor or on the wizard for object actions such as Drop or Rename.
Platform Availability
- DB2 z/OS version 9 ^
To Exchange Data Between One or More Tables and their Clones
- Initiate a Clone Actions > Exchange Data With Clone action against one or more tables. For more information see Initiating an object operation.
- The Exchange Data With Clone dialog opens.
- Use the following table as a guide to understanding and modifying settings in this wizard:
| Step | Settings and tasks | |
|---|---|---|
|
Action Options |
Lets you review the action you initiated. | |
|
Dependencies |
Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies. | |
|
Preview |
Displays the DDL that will execute the object action. For more information, see Preview. | |
- 3. Click Execute. For information on the scheduling option, see Scheduling.
