Failling Db2 USer defined Update

[bhurke.tejaswini]

In DB2 Enterprise stage I am using following options.

user defined 'update & insert' is used with write method as 'Upsert'

Query is like this
" UPDATE
#$HEW_TGT_COUNTRY_SCHEMA#.HEW_IP_IP_REL
SET
END_DT = ORCHESTRATE.END_DT, UPDT_DT_TM = ORCHESTRATE.UPDT_DT_TM, SRCE_SYS_CDE = ORCHESTRATE.SRCE_SYS_CDE,
IP_ID = ORCHESTRATE.IP_ID_REL, IP_ID_REL = ORCHESTRATE.IP_ID WHERE
((IP_ID = ORCHESTRATE.IP_ID_REL AND IP_ID_REL = ORCHESTRATE.IP_ID) AND IP_IP_REL_CDE = ORCHESTRATE.IP_IP_REL_CDE AND START_DT = ORCHESTRATE.START_DT) "

Job is failed with error
"db2HEW_IP_IP_RELups,0: ERROR during execution of DB2-CLI requests: SQL_ERROR; SQLSTATE = HY003; NativeErrorCode = -99999; Message = [IBM][CLI Driver] CLI0122E Program type out of range. SQLSTATE=HY003
."

Is this a problem with the Query or something else? Can we use such user defined update statement on partitioned db?

[ray.wurlod]

You've got IP_ID_REL and IP_ID in different order in the Columns grid and in the SQL, so that the parameter markers are not lining up correctly.