DB2 upsert

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Havoc
Participant
Posts: 110
Joined: Fri Nov 24, 2006 8:26 am

DB2 upsert

Post by Havoc »

I am trying to udpate a partitoned table using the upsert mode in the DB2 UDB Enterprise Stage. But the following fatal error keeps occuring:

DB2_TEST: When preparing operator: When binding partitioner interface: Could not find input field "sk".

I am using a User Defined Update and the partitioning key in this table is 'SK'.
The update statement does not contain the column 'SK'.

Can anyone please tell me why this problem is happening and a solution for this?

Input Partitioning in DB2 stage is DB2 Partitioning.
Post Reply