LOWVALUES={
N|Y} 

N
.
PowerExchange does not preserve hexadecimal '0' 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.
Y.
PowerExchange preserves hexadecimal '0' values in the column string. The entire column string, including the low value, is written to the target.

To ensure that the source hexadecimal '0' values are preserved during a PowerCenter session, you must use the PowerExchange Client for PowerCenter (PWXPC) interface instead of the PowerExchange ODBC interface.
To write hexadecimal '0' values from a supported data source to a supported data target without any translation of the values, complete the following tasks:
Specify LOWVALUES=Y in the DBMOVER configuration file on the Integration Service machine.
In Powercenter Workflow Manager, on the
Config Object
tab for the session, enter
PreserveLowValues=Yes
in the
Custom Properties
field.
In the source and target connections in the PowerCenter workflow, ensure that the
Convert character data to string
option is
not
selected.
In PowerCenter, you can override the LOWVALUES setting in the DBMOVER configuration file by entering LOWVALUES={Y|N} in the
PWX Override
connection attribute. You can then use the connection in a session to implement the override for a specific source or access method.