|
View previous topic :: View next topic
|
| Author |
Message |
krunalbafna
Warnings : 1
Active User
Joined: 18 Jan 2010
Posts: 143
Location: Pune
|
|
|
|
I have one load PS file. WHile loading the data i need to take care that the original records shld not be deleted and new records are to be inserted based on following contions-table should not have multiple entries with CUST_NO,SYS_CDE and APPL_NO. I am using following query:
LOAD DATA RESUME YES LOG NO NOCOPYPEND INDDN SYSREC00 INTO TABLE .tablename
Here the orginal data is deleted and new records are just inserted.
Kindly revert . |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hello Krunal,
You have used RESUME YES so it wont delete existing record .It will insert the record if RI , Uniqueness or primary key not voilted otherwise ignore that record. |
|
| Back to top |
|
|
krunalbafna
Warnings : 1
Active User
Joined: 18 Jan 2010
Posts: 143
Location: Pune
|
|
|
|
Hi ekta,
There is no primary key defined for the table.
Also i did not got what does RI mean,
Shall i use query in following way:
LOAD DATA RESUME NO LOG NO NOCOPYPEND INDDN SYSREC00 INTO TABLE .tablename |
|
| Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
| Please post in the appropriate forum next time. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Did you read this . . .?
| Quote: |
| You have used RESUME YES so it wont delete existing record |
Does this tablespace have multiple tables? |
|
| Back to top |
|
|
|
|
