|
View previous topic :: View next topic
|
| Author |
Message |
kumar_ngl
Warnings : 1
New User
Joined: 05 Aug 2005
Posts: 50
Location: chennai
|
|
|
|
hi all
how to eliminate the dupilcate records while loading a flat file into a VSAM??
kumar.p.v |
|
| Back to top |
|
 |
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005
Posts: 463
|
|
|
|
Hi,
| Quote: |
| how to eliminate the dupilcate records while loading a flat file into a VSAM?? |
You have to add one simple step before loading the flat file into VSAM
| Code: |
//STEP01 EXEC PGM=SORT
//SORTIN DD DSN=Input FIle,DISP=SHR
//SORTOUT DD DSN=Same as Input File,DISP=SHR
//SYSIN DD *
SORT FIELDS=(1,5,CH,A)
SUM FIELDS=NONE
/*
//SYSOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=* |
Hope it helps
Regards
Rupesh |
|
| Back to top |
|
|
kumar_ngl
Warnings : 1
New User
Joined: 05 Aug 2005
Posts: 50
Location: chennai
|
|
|
|
thanx rupesh.. apart from sorting using sum fileds=none is there any code to do the same thing..
kumar.p.v |
|
| Back to top |
|
|
|
|
