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

Viewing Metadata Extensions

Viewing Metadata Extensions

Nonrelational source and target definitions have metadata extensions that displays additional information from the data map used to create the definition. With VSAM and sequential definitions, the File Name extension field can be modified.
You can override the data map name and schema name in the session properties.
The following table describes the extensions on the Metadata Extensions tab for a nonrelational definition:
Extension Name
Description
Access Method
Method that you specified in the data map to access the source database:
  • A = Adabas
  • D = IMS DL1
  • E = VSAM ESDS
  • I = IDMS
  • K = VSAM KSDS
  • O = IMS ODBA
  • N = VSAM RRDS
  • S = sequential (SEQ)
  • W = DB2 unload file (DB2UNLD)
  • X = Datacom
  • Z = DB2 data map
comments
Any comments.
File Name
Name of the data set (sequential or VSAM only).
Hierarchy Structure
For source and target definitions for which you selected
Use Sequence Fields
, the XML that describes the hierarchy structure of the data. Click the arrow in the
Value
column to display the XML.
For more information, see Hierarchy Structure.
Map Name
Name of the data map.
Schema Name
Name of the schema on which you based the data map.
Use Sequence Fields
Whether to generate sequence fields for the source and target definitions. For more information, see Multi-Group Writes to IMS Unload Files (SHARED).

0 COMMENTS

We’d like to hear from you!