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 4. Create One Output Row for All Elements in an Array

Step 4. Create One Output Row for All Elements in an Array

Create a single row of output for a record that contains an array. All elements in the array appear in a single row.
  1. In the
    Table Properties
    dialog box for the row_out table, select options to create one output row for all elements in the array.
    The following table describes these options:
    Option
    Description
    Fields
    Clear the
    items
    field.
    How do you want to handle multiple instances of selected records
    Select
    Array
    .
    Array
    Select
    1
    .
    New Row on Overflow
    Select this option. PowerExchange populates the output row until it is full and then displays a new row with the overflow records.
  2. Click
    OK
    .
  3. To test the data map, run a database row test. Access the data map locally and select
    NRDB
    in the
    DB Type
    list in the
    Database Row Test
    dialog box.
    In the
    Database Row Test Output
    window, one row appears for each record. All elements of the array in a record appear in a single row.

0 COMMENTS

We’d like to hear from you!