If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
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
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - 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.