Update existing or insert new rows

venugopal81 · Post by **venugopal81** » Mon Aug 08, 2005 7:45 am

Hi All,

We have extracted data from SAP-BW and loaded data in to DB2 database server. We using update existing or insert new rows option.
But problem is records or not updated, but records inserted.

Can you please suggest me on this....

Thanks & regards
venu

ArndW · Post by **ArndW** » Mon Aug 08, 2005 7:51 am

This usually occurs when you do not have indices defined correctly; i.e. there is a difference between the keys used in the Db and those used in the lookup for the insert/update.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Aug 08, 2005 9:58 am

I will say it is more to do with the keys defined in the target cols than in the db.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 08, 2005 6:42 pm

Of course, if every record was new - that is, not already in the target table - you would also (correctly) observe no records being updated and all records inserted.

chulett · Post by **chulett** » Mon Aug 08, 2005 8:29 pm

When you get right down to it, it's not about 'new' versus 'old' but - based on the fields you marked as keys - where any rows in the target database actually updated? When zero rows are updated that triggers the call to the insert... which can still fail because the 'real' keys already exist on another record or in another unique index.