DB2 upsert
Posted: Fri Sep 21, 2007 9:18 am
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.
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.