Skip to Content

EXCH (Exchange Clone and Base Table Data)

The EXCH row command generates SQL to switch the data (content) of a base table and its associated clone table. This command is valid in table lists. When entering the command, the Edit From and To for Exchange Clone Data screen (see the following figure) displays.

To generate EXCHANGE DATA SQL from multiple tables, use the EXCH primary command.

Edit From and To for Exchange Clone Data

image2021-5-7_15-24-29.png

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI DevX File-AID for Db2 23.01