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. Create an Output Row for Each Element in an Array

Step 3. Create an Output Row for Each Element in an Array

Create an output row for each element in an array.
  1. In the
    Data Map
    tab in the
    Resource Explorer
    , right-click the
    row_out
    table and click
    Properties
    .
    The
    Table Properties
    dialog box appears.
  2. In the
    Table Properties
    dialog box, select options to create an output row for each element in the array.
    The following table describes these options:
    Option
    Description
    Fields
    Select
    Groups and Arrays only
    . This option displays fields defined as a group or an array field in the list.
    Fields
    Select the items field. In this list, you can select fields that are defined as groups or arrays.
    How do you want to handle multiple instances of selected records
    Select
    New Row
    . This option causes each occurrence of the data in the items field to appear in its own row.
  3. Click
    OK
    .
  4. On the
    Data Map
    tab, double click the
    row_out
    table to open the
    Table Properties
    dialog box.
    The
    items_L
    column appears in turquoise, which indicates that it is part of an array.
  5. To test the data map, run a database row test. Access the data map locally and click
    NRDB
    in the
    DB Type
    list in the
    Database Row Test
    dialog box.
    The
    Database Row Test Output
    window displays multiple output rows from a single input record, depending on the number of elements in the array.

0 COMMENTS

We’d like to hear from you!