CRCT (Create Clone Table for Base Table)

The CRCT row command generates SQL to create a clone table (table type ‘C’) for the selected base table. This command is valid in table lists. When entering the command, the Edit Create Clone Table window (see the following figure) displays. By default, File-AID for Db2 Object Administration uses the base table name and adds the _CT suffix to name the new clone table. You can only add one clone table to a base table. Refer to the IBM Db2 documentation for limitations on creating a clone table.

You can also create a clone table for a base table from the TABLE ALTER display, using the ADD_CLONE primary command (see ADD_CLONE).

Create Clone Table for Base Table with vertical view