Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

WRT_ERROR_HANDLING Statement

WRT_ERROR_HANDLING Statement

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.
If you specify WRT_ERROR_HANDLING=Y and set the
Write Mode
connection to
Confirm Write Off
, this statement is ignored.