View previous topic :: View next topic
|
Author |
Message |
zatish
New User
Joined: 06 May 2005 Posts: 14
|
|
|
|
Pls let me know the diff btw
LOAD RESUME and LOAD REPLACE
Thks |
|
Back to top |
|
|
amitava Warnings : 1 Active User
Joined: 30 Oct 2005 Posts: 186 Location: India
|
|
|
|
Hi zatish,
I think by LOAD RESUME it means that the loading into DB2 table it will just start loading where after it was stopped. All the old datas will be available after loading here.
But by LOAD REPLACE it means that the table will be truncated and then the loading will take place. So by this way, all the old datas will not be available. |
|
Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
Hi,
LOAD RESUME will append the data to the table. That means you won't lost existing data.
LOAD REPLACE will delete the existing data in tablespace(i.e all the tables in tablespace will lost the data) and load the given data in mentioned table.
Hope you got me.
Thanks
Raghavendra |
|
Back to top |
|
|
|