DSXchange

Hi

I designed a job using change capture. The design is like this


DB2API----| |==ODBC
| |
|==Change Capture==Transformer==|
DB2API----| |==ODBC==ODBC

In the Transformer i put the link constraint

Lnk_Capture.change_code=3 or Lnk_Capture.change_code=1

for update and insert ,

Lnk_Capture.change_code=2

for deleted records.

What is my mistake, why i am getting below Fatal error.

Insert: Field: change_code in the input not found in db table: DB2DODS2.TN1ODSHD and drop option was not specified

The error says that change code is not present in the table you are trying to write.

So either you have mapped change code to the output link or RCP is creating the problem.

check transformer/project settings for both the cases.