error in doing UPSERT mode in DB2UDB
Posted: Mon Sep 20, 2010 4:04 am
Hi All,
I have the job design as :
dataset----->DB2
dataset with two columns ORDER_NBR(decimal 9,0) and order_key(integer 10)
DB2 stage is having other columns as sesion_key,update_time,ORDER_NBR(decimal 9,0),order_key(integer 10).
I'm using write method:upsert and upsert method is Auto-generatedupdate only.(update sql :UPDATE #$prsnt_SchemaName#CS_ORDER_FACT SET ORDER_KEY = ORCHESTRATE.ORDER_KEY WHERE (ORDER_NBR = ORCHESTRATE.ORDER_NBR)
but the job is getting abort giving the error as "session_key in the input dataset.
Missing field: session_key in the input dataset".
Please let me know where I'm doing wrong?
Thanks,
Kalpana.
I have the job design as :
dataset----->DB2
dataset with two columns ORDER_NBR(decimal 9,0) and order_key(integer 10)
DB2 stage is having other columns as sesion_key,update_time,ORDER_NBR(decimal 9,0),order_key(integer 10).
I'm using write method:upsert and upsert method is Auto-generatedupdate only.(update sql :UPDATE #$prsnt_SchemaName#CS_ORDER_FACT SET ORDER_KEY = ORCHESTRATE.ORDER_KEY WHERE (ORDER_NBR = ORCHESTRATE.ORDER_NBR)
but the job is getting abort giving the error as "session_key in the input dataset.
Missing field: session_key in the input dataset".
Please let me know where I'm doing wrong?
Thanks,
Kalpana.