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?
Failling Db2 USer defined Update
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 2
- Joined: Wed May 23, 2007 4:32 am
- Location: Pune
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: