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.
Need help with DB2 Enterprize stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.