|
View previous topic :: View next topic
|
| Author |
Message |
tarakanta
Warnings : 1
New User
Joined: 30 Jan 2007
Posts: 10
Location: Hyderabad
|
|
|
|
Hi,
i have a query:
While using DB2 load utility (DSNUTILB), what is the option to append the new records/data to already existing rows?
Thx |
|
| Back to top |
|
 |
srikanthkailasam
New User
Joined: 13 Nov 2006
Posts: 24
Location: Bengalooru
|
|
|
|
In SYSPUNCH, give RESUME YES. This will add new rows to the DB without replacing the existing rows.
| Code: |
| LOAD DATA REPLACE YES LOG NO INDDN SYSREC00 INTO TABLE COMPANY_NAME |
|
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Tara,
As srikanth said with RESUME YES but not as in the code.
LOAD DATA RESUME YES INTO TABLEDSN8910.DEPT
Thank You,
Sushanth |
|
| Back to top |
|
|
|
|
