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

Multiple-Record Writes to Nonrelational Targets

Multiple-Record Writes to Nonrelational Targets

During bulk data movement sessions, PowerExchange can use a multiple-record data map to read data from a nonrelational data source and write the multiple record types in a single pass to a nonrelational target. This process is called a
multiple-record write
.
When PowerExchange performs a multiple-record write, it preserves source sequencing information. To enable multiple-record writes with sequencing, select the
Multi-Record Datamaps
and
Use Sequence Fields
options in the
Import from PowerExchange
dialog box for both the source and target definition. When you select these options, PowerExchange generates primary key and foreign key fields for each group in the source and target definitions and also stores metadata about these record relationships in XML format.
You can perform multiple-record writes with the following types of sources and targets:
  • Source and target IMS unload data sets on z/OS
  • Any combination of the following types of nonrelational sources and targets:
    • Sequential or VSAM ESDS, KSDS, or RRDS data sets on z/OS
    • Files on Linux, UNIX, or Windows
    • Files on i5/OS

0 COMMENTS

We’d like to hear from you!