Load data to the VSAM file from sequential(with duplicates)

gileshpg · New User Joined: 22 May 2008 Posts: 27 Location: Bangaluru

Hi,
I am having a sequential file of 100 bytes, need to load to the vsam file using repro.
The first 5 bytes of the VSAM is the key field.
The sequential file will have duplicates, so using repro it is showing abend.(The VSAM file will be empty)
I used
REPRO INFILE(FILEIN) OUTFILE(FILEOUT) -
REPLACE

The input file is like

11111 abcde..........
11111 gfsdjhs...........
22222 gffffffffffd...............
33333 gdffffffhdh..............
55555 hhhhhddddd................

Output I need

11111 gfsdjhs...........
22222 gffffffffffd...............
33333 gdffffffhdh..............
55555 hhhhhddddd................

Can anyone help me on this.

PeterHolland · Posted: Fri Jul 23, 2010 11:01 am

Sort the file removing the dups.

gileshpg · New User Joined: 22 May 2008 Posts: 27 Location: Bangaluru

is there any other way that we can do this in one step without using sort??? my input have millions of data.....

expat · Posted: Fri Jul 23, 2010 11:35 am

The output from sort can be written directly into the KSDS.