DSXchange

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.SRC...

Is it possible that Job is failed with Fetal error but still its showing the status as Finished Status in Director and also return code as 0 ?