Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: PowerExchange Client for PowerCenter (PWXPC)
  4. Part 3: PowerExchange ODBC
  5. Appendix A: PowerExchange Interfaces for PowerCenter Tips
  6. Appendix B: Datatypes and Code Pages
  7. Appendix C: PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Editing Metadata Extensions

Editing Metadata Extensions

With VSAM and sequential definitions, the File Name extension field can be modified. All other field populated by PWXPC when a data map is imported cannot be changed.
By default, the File Name field contains the value from the PowerExchange data map File Name field which contains the VSAM data set name or the sequential file name.
Any VSAM and sequential definitions created prior to PowerCenter 8.5 will have a blank File Name. If desired, this field can be populated manually or by re-importing the data map.
The following procedure explains how to manually update the File Name field to add or change the file name in a VSAM or sequential definition.
To edit metadata extensions:
  1. Double-click the source or target definition in the workspace.
  2. Select the Metadata Extensions tab.
    PWXPC populates the
    File Name
    field with the File Name for the PowerExchange data map.
  3. Click in the
    Value
    field and select the down arrow.
    The Edit Metadata Extension Value panel appears, allowing you to enter or change the file name.
  4. Click
    OK.
  5. Click
    OK
    to end Edit Tables.
You can also re-import the PowerExchange data map to automatically populate the
File Name
field with the information contained in the data map.

0 COMMENTS

We’d like to hear from you!