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.4
  • 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 3. Add User-Defined Fields

Step 3. Add User-Defined Fields

In this step, you add user-defined fields.
The user-defined fields invoke the PowerExchange CallProg function, which calls the user exit program. For more information about the CallProg function, see CallProg.
The user exit program processes data in and returns the class types of the REC_TYPE, BIN_NO, and DECIMAL_NO fields.
  1. Open the demo.userexit data map and the MASTER_REC record.
  2. In the
    Record
     window, click the
    Expr(0)
     tab.
  3. Right-click anywhere on the
    Expr(0)
     tab and click
    Add Field at End
    .
  4. Add the classtype_rec_type field, which is an output field that contains the result from the user exit program when it is invoked for the REC_TYPE field.
    The following table describes the properties to define for the field:
    Property
    Value
    Name
    classtype_rec_type
    Type
    CHAR
    Precision
    0
    Scale
    0
    Length
    1
  5. Right-click anywhere on the
    Expr(0)
     tab and click
    Add Field at End
    .
  6. Add the rc_rec_type field, which calls the user exit program to process the REC_TYPE field.
    The following table describes the properties to define for the field:
    Property
    Value
    Notes
    Name
    rc_rec_type
    -
    Type
    NUM32
    -
    Precision
    0
    -
    Scale
    0
    -
    Length
    0
    -
    Phase
    RW
    Indicates that the operation is read or write.
    Expression 
    CallProg('UCPGCLSC',
'UCPGCLSC','COBOL',
REC_TYPE,classtype_rec_type)
    To enter the expression for the field, complete the following steps:
    1. Click in the cell in the
      Expression
       column and click the Browse button. The
      Expression Editor
       dialog box appears.
    2. In the
      Function List
       list in the
      Expression Editor
       dialog box, double-click the CallProg function.
    3. In the
      Expression List
       list, enter
      ('UCPGCLSC','UCPGCLSC','COBOL',REC_TYPE,classtype_rec_type)
       at the end of the CallProg function name.
    4. Click
      Validate
      . In the
      Validate
       box, the
      No Errors
       message appears.
    5. Click
      OK
      .
  7. In the
    Record
     window, click the
    Expr(0)
     tab.
  8. Right-click anywhere on the
    Expr(0)
     tab and click
    Add Field at End
    .
  9. Add the classtype_bin_no field, which is an output field that contains the result from the user exit program when it is invoked for the BIN_NO field.
    The following table describes the properties to define for the field:
    Property
    Value
    Name
    classtype_bin_no
    Type
    CHAR
    Precision
    0
    Scale
    0
    Length
    1
  10. Right-click anywhere on the
    Expr(0)
     tab and click
    Add Field at End
    .
  11. Add the rc_bin_no field, which calls the user exit program to process the BIN_NO field.
    The following table describes the properties to define for the field:
    Property
    Value
    Notes
    Name
    rc_bin_no
    -
    Type
    NUM32
    -
    Precision
    0
    -
    Scale
    0
    -
    Length
    0
    -
    Phase
    RW
    Indicates that the operation is read or write.
    Expression 
    CallProg('UCPGCLSC',
'UCPGCLSC','COBOL',
BIN_NO,classtype_bin_no)
    To enter the expression for the field, complete the following steps:
    1. Click in the cell in the
      Expression
       column and click the Browse button. The
      Expression Editor
       dialog box appears.
    2. In the
      Function List
       list in the
      Expression Editor
       dialog box, double-click the CallProg function.
    3. In the
      Expression List
       list, enter
      ('UCPGCLSC','UCPGCLSC','COBOL',BIN_NO,classtype_bin_no)
       at the end of the CallProg function name.
    4. Click
      Validate
      . In the
      Validate
       box, the
      No Errors
       message appears.
    5. Click
      OK
      .
  12. Right-click anywhere on the
    Expr(0)
     tab and click
    Add Field at End
    .
  13. Add the classtype_dec_no field, which is an output field that contains the result from the user exit program when it is invoked for the DECIMAL_NO field.
    The following table describes the properties to define for the field:
    Property
    Value
    Name
    classtype_dec_no
    Type
    CHAR
    Precision
    0
    Scale
    0
    Length
    1
  14. Right-click anywhere on the
    Expr(0)
     tab and click
    Add Field at End
    .
  15. Add the rc_decimal_no field, which calls the user exit program to process a copy of the DECIMAL_NO field.
    The following table describes the properties to define for the field:
    Property
    Value
    Notes
    Name
    rc_decimal_no
    -
    Type
    NUM32
    -
    Precision
    0
    -
    Scale
    0
    -
    Length
    0
    -
    Phase
    RW
    Indicates that the operation is read or write.
    Expression 
    CallProg('UCPGCLSC',
'UCPGCLSC','COBOL',
DECIMAL_NO,classtype_dec_no)
    To enter the expression for the field, complete the following steps:
    1. Click in the cell in the
      Expression
       column and click the Browse button. The
      Expression Editor
       dialog box appears.
    2. In the
      Function List
       list in the
      Expression Editor
       dialog box, double-click the CallProg function.
    3. In the
      Expression List
       list, enter
      ('UCPGCLSC','UCPGCLSC','COBOL',DECIMAL_NO,classtype_dec_no)
       at the end of the CallProg function name.
    4. Click
      Validate
      . In the
      Validate
       box, the
      No Errors
       message appears.
    5. Click
      OK
      .
0 COMMENTS
We’d like to hear from you!