Comparing data structures

You can use the DISPLAY command to display the table layout of an ACL table. The table layout specifies the data structure of the table.

Before appending a source table or output results to a target table, you can display the table layouts of both tables and visually compare the structures to check if they are identical. The data structures of the two tables must be identical in order for the append operation to work correctly.

The following data structure elements are displayed by the DISPLAY command:

To compare data structures:

  1. Open the source table.
  2. Enter DISPLAY in the command line and click Run .

    Data structure information for the source table is displayed in the Results tab.

  3. Click the pin icon to pin the Results tab and preserve the data structure information.
  4. Open the target table.
  5. Enter DISPLAY in the command line and click Run .

    Data structure information for the target table is displayed in a second Results tab.

  6. Click the pin icon to pin the Results tab and preserve the data structure information.
  7. Click back and forth between the two Results tabs to visually compare the two data structures.

    Any difference in data structures will prevent an append operation from working correctly. You may need to manually harmonize the data structures before performing the append. If you are combining two tables, another option is combining the data outside ACL.

Related concepts
Combining data outside ACL
Data structure and data format requirements
Harmonizing fields
Appending results to ACL tables and text files


(C) 2015 ACL Services Ltd. All Rights Reserved.