Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange for CDC and Mainframe 10.5.1
  • All Products

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

Back Next

Step 1. Add a Data Map and Import a COBOL Copybook into the Data Map

Step 1. Add a Data Map and Import a COBOL Copybook into the Data Map

Add a data map for a sequential flat file and import a COBOL copybook into the data map.
  1. On the
    Resources
     tab in the
    Resource Explorer
    , click
    Add 
    Data Map
    .
  2. In the
    Name
     dialog box, enter information about the data map.
    The following table describes the information to enter:
    Option
    Description
    Schema Name
    Enter
    COBOL
    .
    Data Map Name
    Enter
    map2
    .
    Access Method
    Select
    SEQ
    .
    Import Record Definitions
    Select this option.
  3. Click
    Next
    .
  4. In the
    SEQ Access Method
     dialog box, enter information about the data file.
    The following table describes the information to enter:
    Option
    Description
    File Name
    Click the Browse button to browse to the train3.dat file in the
    examples
     directory.
    Fixed
    Select this option.
    Size
    Enter
    60
    .
  5. Click
    Finish
    .
  6. In the
    Import Copybook - Source Details
     dialog box, enter copybook information.
    The following table describes the information to enter:
    Option
    Description
    Source
    Select
    Local
    .
    Type
    Select
    COBOL
    .
    Start
    Enter
    7
    .
    End
    Enter
    72
    .
  7. Click
    Next
    .
  8. In the
    Import Copybook - Local Cobol Details
     dialog box, click the Browse button to browse to the train3.cob file in the
    examples
     directory.
    To view the copybook, click
    Preview
    .
  9. Click
    Next
    .
  10. In the
    Import Copybook - Configuration Details
     dialog box, select the actions for imported records, fields, and tables and click
    Finish
    . For more information, see Import Copybook - Configuration Details Dialog Box.
  11. In the
    Import Copybook Information
     window, review the information for the import and click
    OK
    .
  12. In the
    Record Definition
     dialog box for the NAME_REC record and the ACCOUNT_REC record, click
    OK
    .
    The
    Cobol Import
     window displays the imported copybook.
    The
    Copybook Message Log
     window displays the results of the import operation.
    To find the associated line in the copybook for an error that appears in the
    Copybook Message Log
     window, double-click the message.
  13. Close the
    Cobol Import
     window.
  14. On the
    Data Map
     tab in the
    Resource Explorer
    , click the
    NAME_REC
     record.
  15. In the
    Record
     window, right-click the
    RECTYPE
     field and click
    Properties
    .
    The
    Name
     tab in the
    Field Properties
     dialog box appears.
  16. In the
    Record ID Values
     box, enter
    01
    .
    To view the original properties for the field from the imported copybook, click the
    Extra Properties
     tab.
  17. Click
    OK
    .
    In the
    Record
     window, the
    RECTYPE
     field icon appears in green.
  18. On the
    Data Map
     tab in the
    Resource Explorer
    , click the
    ACCOUNT_REC
     record.
  19. In the
    Record
     window,
    right-click
     the
    RECTYPE
     field and click
    Properties
    .
    The
    Name
     tab in the
    Field Properties
     dialog box appears.
  20. In the
    Record ID Values
     box, enter
    02
    .
  21. Click
    OK
    .
    In the
    Record
     window, the
    RECTYPE
     field icon appears in green.
  22. On the
    Data Map
     tab in the
    Resource Explorer
    ,
    right-click
    COBOL.map2
     and click
    Add Table
    .
  23. In the
    Add Table
     dialog box, enter information about the table.
    The following table describes the information to enter:
    Option
    Description
    Table Name
    Enter
    both
    .
    Available Records
    Right-click the
    NAME_REC
     record and click
    Add Record
    . Then, right-click the
    ACCOUNT_REC
     record and click
    Add Record as Child
    .
  24. Click
    OK
    .
  25. To view the table output before applying a date mask to the POLICY_DATE record, run a database row test. On the
    Data Map
     tab in the
    Resource Explorer
    , click the
    both
     table and click
    File
     Database Row Test
    .
  26. In the
    Database Row Test
     dialog box, enter information about the database row test.
    The following table describes the information to enter:
    Option
    Description
    DB Type
    Select
    NRDB
    .
    Location
    Select
    local
    .
  27. Click
    Go
    .
    The
    Database Row Test Output
     window displays the output.
  28. Close the
    Database Row Test Output
     and the
    Database Row Test
     windows.
  29. Close the
    Database Row Test Output
     and
    Database Row Test
     windows.
0 COMMENTS
We’d like to hear from you!