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.
error in doing UPSERT mode in DB2UDB
Moderators: chulett, rschirm, roy
error in doing UPSERT mode in DB2UDB
Kalpana Marupudi
no session_key is not present in the dataset,infact dataset is having only two columns that are order_nbr and order_key and i need to update the table in db2.my auto-generated update statament is like :ArndW wrote:Is "session_key" declared in the dataset and passed into the stage? Did you declare "session_key" in the DB2 stage columns and then not use it in your insert or update statements?
UPDATE #$prsnt_SchemaName#CS_ORDER_FACT SET ORDER_KEY = ORCHESTRATE.ORDER_KEY WHERE (INTERNET_ORDER_NBR = ORCHESTRATE.INTERNET_ORDER_NBR)
Kalpana Marupudi
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India