Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

Handling Columns Added with the NOT NULL and DEFAULT Options to a SQL Server Source Table

Handling Columns Added with the NOT NULL and DEFAULT Options to a SQL Server Source Table

Previously, if you captured change data from a Microsoft SQL Server 2012 or later source, capture processing might fail with the following error message after an ADD
column_name
datatype
NOT NULL DEFAULT operation occurred on a source table:
PWX-15748 Invalid Capture data for table
schema
.
table_name
, column
column_name
. Found NULL data expected non-NULL.
PowerExchange processed the added columns after an Update or Delete occurred on the source, but the captured before image showed null values for the not-null columns.
In PowerExchange 10.1, PowerExchange populates the added columns in the before image with an appropriate default non-null value, which is based on the column datatype. PowerExchange then continues capture processing. You cannot change the default values that PowerExchange uses. If the use of these default values is not acceptable in your environment, you must rebuild the source table after the columns are added. Then restart CDC.
For more information, see the "Microsoft SQL Server Change Data Capture" chapter of the
PowerExchange CDC Guide for Linux, UNIX, and Windows
.

0 COMMENTS

We’d like to hear from you!