I 'am using DSNUPROC to load data into Db2 tables.i have a following scenario.
Initially TableA had 50 rows then I loaded 50 rows. so totally now i have 100 rows in TableA. Now i want to replace the 50 rows what ever i've loaded with the new set of data other than primary key.
I went through replace option but it will replace the entire set of 100 rows with the 50 rows whatever i loaded. Is there anyway to replace the 50 rows whatever i've loaded leaving the rest of the 50 rows intact.
Thanks for u'r quick response Ravi.I told that table has 50 rows as example but the table actually has arround 700 million rows and i'am trying to update nearly 10 million rows.unloading all and loading them again will be a tedious task and will take more time as well. Is it possible by any chance to replace those 50 rows alone other than writting any program.