Below are my scenario:
I want to append the new rows to the table using the load replace.and if any existing data is there and the values are changed
in that need to update the values.what is the option i can use in load utility?
with load : only insert or replace
if insert-update is needed : import must be used and you need a pk IMPORT
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
It make sence to do this , but until now there is no solusion do do it with load utility.
You can unload the current data and with syncsort to drop duplicates that are in the unload file.
Maybe now , after we have the MERGE , in the next version it will be posible.