Clone Table Assistant
The Clone Table Assistant is a CONNX tool that simplifies the process of creating a copy of a table definition containing fewer fields than the original. This is useful for tables that contain more than 255 columns, because many popular tools cannot use tables that contain more than 255 fields. With the Clone Table Assistant, virtual tables that contain limited information and increase data security and usability can be created.
1. Select a table to clone in the CONNX Data Dictionary Manager window, and then click the Clone Table button.
The CONNX Table Clone Assistant window appears.
2. Type a name for the new table in the New Table Name text box.
The naming conventions are as follows:
Maximum size is 50 characters.
Table name cannot contain spaces.
Table name cannot begin with a number.
Table name must be unique.
3. Highlight the fields in the original table to include in the new table, and then click Add. If not including one of the fields selected for the new table, select the field and then click Remove.
Note:
If you are cloning an IMS table, include all the virtual columns that relate to the parent key. These columns have a CNX_ prefix and are used to preserve the table hierarchy. If you do not include these columns, CONNX can not properly navigate the table hierarchy and may cause unpredictable results.
4. Click OK.
The newly cloned table contains a subset of available fields, selected from the original table.