After a column with a default value is added, the default value is not propagated when a row is deleted.

Technote (FAQ)

Question

When a column is added using default values, the Capture program does not use the default value on any row that existed prior to the column being added. Instead, a system default value is used.

Cause

Capture gets each column value from log records. If the row existed before the column was added, there is no data for this column in the log record and the column values would contain the system default value. If the row was inserted or updated after the ALTER ADD operation, the column would have data either explicitly or the column would contain the user-defined default value.

Answer

1. Execute a REORG on the source table after you add the column. 2. Update the source table prior to applying any changes.