DSXchange

Hi, I'm new in DS job developmen and I triying to create a new job composed by:
CDC_Transaction->Transformer->JDBC_Connector
I test my results updating, inserting and deleting but, I have problems if I try to do a "Delete then Insert" operation.
My job crash because "I did'tn refer all my columns in the statemen"

My question is:
How I can directly refer a specific column in my job?

many thanks

What is value of "Drop unmatched fields" in the JDBC stage properties?

The value is set to NO.
I understand that the field should be worth YES, but I still don't know how to correlate the information I get with the specific columns I want to write.

You can see the SQL statement performing Delete and subsequent Insert in DataStage Director. Confirm that ALL columns that the connector can be paired with the target table.

Hi!

I'm performing test of my issues and it's failing again.

How i pair the columns in JDBC_Connector?

Thanks

So...
Can anyone helping please?

Many thanks!

The Delete operation requires at least one column to be marked as Key. If this is being done in SQL, the Key columns are used in the WHERE clause.