UPDATE EDW.ITEM_DWP_T SET
SEL_METHOD=:SEL_METHOD,BASED_ON=:BASED_ON,DATE_PERSP=:DATE_PERSP,
DWP_TYPE=:DWP_TYPE,DWP_STATUS=:DWP_STATUS,BU_CODE_SUP=:BU_CODE_SUP,
BU_TYPE_SUP=:BU_TYPE_SUP,SC_ITEM_VOL_NET=:SC_ITEM_VOL_NET,
DQ_IND=:DQ_IND,RUN_ID=:RUN_ID,UPD_DATE=:UPD_DATE
WHERE ITEM_NO=:ITEM_NO AND ITEM_TYPE=:ITEM_TYPE
AND FROM_DATE=:FROM_DATE AND TO_DATE=:TO_DATE
AND SOURCE_FLAG=:SOURCE_FLAG
RETURNING COUNT(ROWID) INTO :16.
I used user generated update then Insert in oracle connector stage.Job is working fine and in director the update statement is shown as above.Could any explain what is meant by RETURNING COUNT(ROWID) INTO :16 and i did not mention that one in the query in oracle connector stage? I know what is meant by ROWID in oracle
This statement doesn't give any error, it is added by the datastage to give you the number of rows it updated. If you see the log, you will have a statement - Number of rows updated on the current node: x. the number of rows are coming from this variable.
The original poster wanted the clarification and there was no error mentioned.
This is the error we get when update statement is using more than two columns in where condition and data is not matching for columns(used in where condition). I have overcome this error now and job is running fine.