| View previous topic :: View next topic |
| Author |
Message |
haseen_mohammed
Beginner
Joined: 20 Feb 2006
Posts: 27
Topics: 14
|
 Posted: Tue Aug 28, 2007 9:06 am Post subject: BMCLOAD Job .. |
 |
|
Hi,
While loading data into table from a CSV file using BMCLOAD (Load Replace).
The load card I am having is discarding both the duplicate rows.
i.e if row 1 & 3 are having duplicate keys. It discards both.
The data card I am using is
LOAD DATA INDDN SYSREC RESUME YES LOG NO COPY YES
EBCDIC CCSID(285,65534,65534)
FORMAT CSV TERMINATEDBY ',' ENCLOSEDBY '"' AND '"'
INTO TABLE XXXXX
REPLACE (
Values ..........)
How can I change the datacard in such a way that atleast row 1 will get inserted into the table.
Haseen |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Tue Aug 28, 2007 11:34 am Post subject: |
|
|
haseen_mohammed,
Use the parm SQLAPPLY to handle duplicates differently from other load types. For this type of load, if the input file contains duplicate rows, LOADPLUS loads the first one that it encounters and discards any subsequent ones.
| Code: |
LOAD DATA INDDN SYSREC RESUME YES LOG NO SQLAPPLY COPY YES
|
Hope this helps..
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
