Table of Contents

Search

  1. Preface
  2. PowerExchange Navigator Introduction
  3. Data Maps
  4. Data Maps for Specific Data Sources
  5. Copybooks
  6. Registration Groups and Capture Registrations
  7. Extraction Groups and Extraction Maps
  8. Personal Metadata
  9. Database Row Test
  10. PowerExchange Navigator Examples
  11. Appendix A: PowerExchange Functions for User-Defined Fields
  12. Appendix B: User Access Method Programs
  13. Appendix C: Application Groups and Applications
  14. Appendix D: Data Map Properties
  15. Appendix E: Record, Field, and Table Properties
  16. Appendix F: DTL__CAPXTIMESTAMP Time Stamps
  17. Appendix G: Trace for Creating a Memory Map When Importing a COBOL Copybook

Navigator User Guide

Navigator User Guide

Step 3. Define a Hierarchy of Records in a Multiple-Record Data Map

Step 3. Define a Hierarchy of Records in a Multiple-Record Data Map

Define a hierarchical relationship between the rec1 and rec2 records to reflect the actual hierarchy in the data source.
  1. On the
    Data Map
    tab in the
    Resource Explorer
    , right-click the
    row_out
    table and click
    Properties
    .
    The
    Record Dependencies
    list displays the hierarchy between the rec1 and rec2 records.
  2. To delete this hierarchy, in the
    Record Dependencies
    list, right-click
    rec2
    and click
    Delete
    .
    This action moves the rec2 record to the
    Available Records
    list.
  3. In the
    Record Dependencies
    list, right-click
    rec1
    and click
    Delete
    .
    This action moves the rec1 record to the
    Available Records
    list.
  4. To redefine the hierarchy, in the
    Available Records
    list, right-click
    rec1
    and click
    Add Record
    .
    This action moves the rec1 record to the
    Record Dependencies
    list.
    For this record, the
    How do you want to handle multiple instances of selected record
    option is set to
    New Row
    .
  5. In the
    Available Records
    list, right-click
    rec2
    and click
    Add Record as Child
    .
    This action moves the rec2 record to the
    Record Dependencies
    list as a child record of the rec1 parent record.
    For this record, the
    How do you want to handle multiple instances of selected record
    option is set to
    New Row
    .
  6. Click
    OK
    .
    In the
    Table
    window, the name column is based on the name field in the rec1 record, and the address column is based on the address field in the rec2 record.
    The name for each column in the table is prefixed with the record name on which the column is based.

0 COMMENTS

We’d like to hear from you!