| IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
sid_aec
Joined: 01 Jul 2008
Posts: 9
Location: Kolkata
|
| Posted: Mon Aug 18, 2008 5:53 pm Post subject: Reagarding load to DB2 Table |
|
|
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
Joined: 14 Sep 2007
Posts: 184
Location: Pune
|
| Posted: Mon Aug 18, 2008 7:16 pm Post subject: |
|
|
Try,
LOAD DATA RESUME YES LOG NO |
|
| Back to top |
|
sid_aec
Joined: 01 Jul 2008
Posts: 9
Location: Kolkata
|
| Posted: Tue Aug 19, 2008 9:55 am Post subject: |
|
|
| Thanks a lot to you.... |
|
| Back to top |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|
