PowerExchange Interfaces for PowerCenter

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

Back Next

Preserving Low Values in Source Character Fields

If a data source includes character fields with hexadecimal '0' values, called low values
, you can configure PowerExchange and PowerCenter to preserve these values so that a PowerCenter session can write the low values to a VSAM target on z/OS or to a sequential file target on Linux, UNIX, Windows, or z/OS.

To preserve low values, perform the following configuration tasks:

Configure a PowerCenter session that uses the PowerExchange Client for PowerCenter (PWXPC) instead of the PowerExchange ODBC interface.

If you want to write low values from a nonrelational data source on z/OS to a nonrelational target on z/OS without any translation of the values, complete the following tasks in PowerCenter:

On the

Config Object

tab for the session, enter

PreserveLowValues=Yes

in the

Custom Properties

field.

In the source and target PWX NRDB Batch application connections that are included in the PowerCenter workflow, ensure that the

Convert character data to string

option is not
selected.

In the DBMOVER configuration files on the source system and the Integration Service system, set the LOWVALUES statement to Y. For more information, see the

PowerExchange Reference Manual

If you do not perform these configuration tasks, PowerExchange does not preserve low values. It interprets a hexadecimal '0' value as the end of a column string and pads the remaining length of the string with spaces. The portion of the column string after the hexadecimal '0' value is not written to the target.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Preserving Low Values in Source Character Fields

Preserving Low Values in Source Character Fields