Bulk Data Movement Guide

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Session Properties for Writer Partitions

For bulk data movement sessions with writer partitions, you can specify certain session properties at the session level and at the partition level. These properties are optional.

At the session level, you can enter the following session properties for VSAM data sets:

Insert Only

Truncate Table Option

For individual partitions, you can enter the following session properties, including overrides, for either VSAM or sequential file targets:

File Name Override

Insert SQL Override

Post SQL

Pre SQL

For the

Pre SQL

session property, enter SQL statements that can be executed in each partition. If you enter a statement such as CREATEFILE that can be executed only once for the session, the session fails.

For more information about these properties, see

PowerExchange Interfaces for PowerCenter

Based on the

PWX Partition Strategy

session property and whether you specify the same or different partition-level session properties across the partitions, the joiner determines whether to use a single target connection or multiple target connections.

If you select

Single Connection

for the

PWX Partition Strategy

property, the session uses a single connection. If you enter session properties for the first partition only, the PowerCenter Integration Service applies the properties to all other partitions. If you specify different session properties across the partitions, the session fails.

If you select

Overrides Driven

and enter the same session properties for all partitions, the session uses a single connection to the target. If you enter different session properties for the partitions, the session uses multiple connections, one for each partition.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Session Properties for Writer Partitions

Session Properties for Writer Partitions