DSXchange

I am trying to perform Upsert using DB2 enterprize stage over a table which has 3 Primary key columns (Composite primary key) but while performing the upsert i have specified ony 2 out of the 3 key columns. It is aborting with a message that the third columns is missing in the input data set. How can i perform the update???
The same job when coded in server rather than PX worked fine.

PX checks more thoroughly. Try removing the "Key" property from the unused column in the metadata in your job, though I will make no guarantees that this will solve your problem.