ISSUE IN copying Sequential file records in VSAM KSDS file

thesumitk · Active User Joined: 24 May 2013 Posts: 156 Location: INDIA

I am trying to copy input file in Output VSAM file, with delete define option.

Example in input file I have 100 records with Key1 to Key100 and Output VSAM is having Key1 to Key999.

My output should have only Input file Key1 to Key100.
Am trying with
REPRO INFILE (IN1) OUTFILE (OUT1) and using OUT1 disp=old.
But getting error, key already exist. please help, I don't want to delete define the VSAM file.

expat · Posted: Wed Dec 13, 2017 3:15 pm

The input is a PS file ? with the target being a VSAM KSDS I assume.
I assume because your post lacks any real detail.

Why do you believe that using REPRO from a PS file will delete any records not included in the PS file from the output VSAM file ??? Why should this process delete records, please explain your logic here.

You may not want to delete the VSAM file, but tough luck, you're probably going to have to unless you have a program to delete unwanted records.

You need to read up and understand VSAM a lot better than you do.

Robert Sample · Posted: Wed Dec 13, 2017 6:19 pm

You obviously have multiple misconceptions about VSAM (such concepts as REPRO won't replace records, nor will it delete records from the VSAM data set). Start reading VSAM Demystified to learn what you do not understand.