View previous topic :: View next topic
|
Author |
Message |
sid_aec
New User
Joined: 01 Jul 2008 Posts: 60 Location: Kolkata
|
|
|
|
Hi,
When we load through load utility in an empty DB2 tablespace we use load cards like
'LOAD DATA LOG NO' ......or else if the tablspace is not empty and we want to replace the entire existing data with new data , we use:
'LOAD DATA REPLACE LOG NO'...like this way.
But I want to append rows into a table means I want to keep existing records as it is and want to add few more rows along with existing rows.
Can anyone please tell me how to do that.I mean is there anything needs to be changed in load card?or what will be the load card to append rows. |
|
Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
Try,
LOAD DATA RESUME YES LOG NO |
|
Back to top |
|
|
sid_aec
New User
Joined: 01 Jul 2008 Posts: 60 Location: Kolkata
|
|
|
|
Thanks a lot to you.... |
|
Back to top |
|
|
|