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

GenVRowKey Example

GenVRowKey Example

Define a data map that contains a record with an array defined by a COBOL OCCURS clause, as follows:
01 RECORD.    03 FIELD1 PIC X(4).    03 FIELD2 PIC X(4) OCCURS 3 TIMES.
The data map includes two source rows that contain the following data:
AAAA111122221111 BBBB555566667777
In this example, two rows contain the following identical data:
AAAA 1111
The GetVRowKey() function generates the following unique table rows:
AAAA 1111 1 AAAA 2222 2 AAAA 1111 3 BBBB 5555 1 BBBB 6666 2 BBBB 7777 3

0 COMMENTS

We’d like to hear from you!