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