I dont think you can get Updates and Insert specific numbers in you have an update/insert option in your target OCI. I believe for that you need to split your inserts or updates. Or predetermine the inserts by doing a simple lookup on the target table.
If someone has knowledge of determining inserts and updates on insert/update option i would be really keen to learn that.
Regards,
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
rafidwh wrote:Now how can i get the count of number of records updated and number of records inserted? Note: Here I am using only one link not two links.
Can't be done.
-craig
"You can never have too many knives" -- Logan Nine Fingers
If you really want the insert/update logic to be handled by the database, all you need to do is do a lookup on the target, that will give you the inserts,
subtract that from the total, that will give you updates.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
DSguru2B wrote:If you really want the insert/update logic to be handled by the database, all you need to do is do a lookup on the target, that will give you the inserts,
subtract that from the total, that will give you updates.
Just a thought ,if you can access the director log ,using dsjob -logdetail command from command line and by using unix commands such as awk, grep get the no of records inserted and updated.
Thanks
Arif
Doing it twice or thrice on the same link gives the same answer everytime. If you mean links by nodes, then, yes..we can get the desired results with two links. But OP's question was, if its possible when updating and inserting through only one link.
Read the original post. They are using a single link with one of the combo update actions so there's no way to get separate numbers for inserted versus updated records.
-craig
"You can never have too many knives" -- Logan Nine Fingers
