Need help with DB2 Enterprize stage

zulfi123786 · Post by **zulfi123786** » Fri Oct 30, 2009 8:03 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 30, 2009 6:23 pm

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.