The WRT_ERROR_HANDLING statement indicates whether to use an alternative method of handling error messages returned from the PowerExchange Listener for bulk data movement sessions that use writer partitioning when the
Write Mode
connection attribute is set to
Confirm Write On
.
Linux, UNIX, or Windows, wherever the PowerCenter Integration Service runs
All
VSAM data sets and sequential files
No
WRT_ERROR_HANDLING={
N
|Y}
N
. Use the default method of handling error messages returned from the PowerExchange Listener on the target.
Y
. Use the alternative method of handling these error messages. The alternative method can be more efficient in a particular situation. Specify Y only under the following conditions:
Writer partitioning is enabled.
The
Write Mode
connection attribute is set to
Confirm Write On
.
The input data for the writer partitions contains many errors.
Default is N.
In PowerCenter, you can override this WRT_ERROR_HANDLING setting for a bulk data movement session that has writer partitions. Enter the WRT_ERROR_HANDLING setting in the
PWX Override
attribute on the PWX NRDB Batch application connection. Use the same syntax as for this DBMOVER statement.