View previous topic :: View next topic
|
Author |
Message |
candyboy
New User
Joined: 13 Nov 2006 Posts: 10
|
|
|
|
Hi,
We are trying to load a DB2 table using a flat file. The input file has duplicate records. While loading, if the DB2 finds a duplicate record, it is discarding both the records.
We need one record out of the duplicate ones to be loaded. Is there anything we can change so that one record is loaded in case of duplicates. We r currently using DSNUTILB to load n specifying " LOAD DATA REPLACE LOG NO ENFORCE NO INDDN SYSREC INTO TABLE
SAUTH.TAWWX".
Thanx
CB |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Prior to the load step execute a sort step that eliminates duplicates on the key field(s). Then load the file that has had the duplicates removed. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
And keep a back-up of original DSN, I'm dealing with the similar issue here - some one deleted my original DSN & it's something to do with 3 years of production data.. |
|
Back to top |
|
|
|