If you import a copybook into a data map to define the layout of data in the source, PowerExchange creates tables and columns in the data map that are based on the imported records and fields.
You can also manually add tables and columns to a data map. Columns in tables are based on fields in records.
You can define a complex table that is based on multiple records. In a data map, a complex table mirrors the hierarchy of records or segments in the associated data source, such as an IMS or CA IDMS/DB database, data set, or sequential data set. When you define a complex table, define a hierarchical relationship among the records on which the table is based. You can also set options that control how records on which columns in the complex table appear in a database row test, and are mapped to rows and columns in a target table.
Open the data map.
On the
Data Map
tab, right-click the data map and click
Add Table
.
Depending on the data source for the data map, view or define the following properties on some of all of the following tabs in the
Table Properties
dialog box:
Definition
. Properties for a complex table, including settings for how records in a complex table appear in a database row test or are mapped in a target table, and how changes in records on which the table is based are reflected in the corresponding columns in the table.
Filter
. Filter columns by name to either include them in or exclude them from a table.
Keys
. For Adabas, the primary key for the table.
IMS Options
. For IMS DL/1 batch and IMS ODBA, properties for segments in a complex table.