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:
record length
field name
number of fields
field order
field start position
field length
field data type
number of decimal places for numeric fields
field format details
To compare data structures:
- Open the source table.
- Enter DISPLAY in the command line and
click Run
.
Data structure information for the source table is displayed in the Results tab.
- Click the pin icon
to
pin the Results tab and preserve the data structure information. - Open the target table.
- Enter DISPLAY in the command line and
click Run .
Data structure information for the target table is displayed in a second Results tab.
- Click the pin icon to
pin the Results tab and preserve the data structure information.
- 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.