Getting Insert and Update rows count
Posted: Tue Jun 07, 2005 11:38 pm
Hi,
We are basically writing into an Oracle Enterprise stage, source is Sequential file stage. We need to find out selected row count and seprate inserted row count and update row count into target table.
I think GetlinkInfo function is not feasible option to achieve this.. as this gives only the row processed through the link.
can anyone suggest anyother datastage function to achieve this?
Thanks
We are basically writing into an Oracle Enterprise stage, source is Sequential file stage. We need to find out selected row count and seprate inserted row count and update row count into target table.
I think GetlinkInfo function is not feasible option to achieve this.. as this gives only the row processed through the link.
can anyone suggest anyother datastage function to achieve this?
Thanks