PowerExchange supports multiple-record writes to VSAM ESDS, KSDS, and RRDS targets. PowerExchange does not support multiple-record writes to VSAM VRRDS targets.

PowerExchange does not support changing the values inside header or trailer records.

A parent must precede its children in the source data.

In PowerCenter, you must create new source and target definitions for multiple-record writes. Existing definitions without sequencing information do not work for multiple-record writes. You can continue to use existing definitions for workflows that do not use multiple-record writes.

A data map for a sequential source or target uses the SEQ access method. A data map for a VSAM target uses one of the following access methods: ESDS, KSDS, or RRDS.

The source data map must specify unique record ID conditions so that each record in the input file is distributed to one and only one table. If the same record is distributed to more than one table, processing fails. This situation can occur if record ID conditions overlap or if you do not define record ID conditions in the data map.

You cannot select which tables in the data map to import. PowerCenter imports all of the simple tables in the data map.

The data map must have exactly one table for each record.

Mapping transformations might drop rows. In this case, ensure that the mapping does not create any orphan rows. When a multiple-record write workflow runs, it drops orphan rows instead of writing them to the target.

The mapping must not alter the position or the name of the generated sequence fields or drop them.

Transformations that insert records into a mapping are not supported.

Transformations that might alter row IDs, including the Sorter, Joiner, and Rank transformations, are not supported.

You can use multiple-record writes with PWXPC NRDB Batch connections only. PowerExchange ODBC connections are not supported.

Select

Off

for the

Confirm Write

source and target connection attributes. If you select a different value, PowerExchange changes the value to

Off

.

In certain cases, you might need to change the value of the

CSQ_MEMSIZE

parameter of the

PWX Override

connection attribute. This parameter defines the maximum amount of memory that the cache can consume for multiple-record writes.

Pipeline partitioning is not supported on the reader or writer for sources or targets that were defined with sequencing enabled.

You can specify the

File Name Override

property for sequential or VSAM sources and targets.

For sources, the

Flush After N Blocks

property specifies the maximum number of block flushes that can occur across all groups without a given block being flushed. Define this property to ensure that all blocks are flushed at regular intervals.

For SEQ targets on z/OS, PowerExchange can allocate the target data sets based on z/OS data set allocation properties that you optionally define in the session properties.