Merging of two VSAM files in to another VSAM file

rajandhla · Posted: Fri Dec 22, 2006 6:10 pm

Hi ,

I have got two VSAM files. I need to merge these two files and copy it into another VSAM file.

I have tried using sort command SORT FIELDS = COPY , At the same time i was unsuccessfull copying the two files in to one VSAM file

Please let me know the appropriate job for this

Regards,
Jayaram

William Thompson · Posted: Fri Dec 22, 2006 6:17 pm

ESDS or KSDS?
How were you "unsuccessfull"?
Tried to just concatenate the DDs?
More info would generate better responses.....

rajandhla · Posted: Fri Dec 22, 2006 6:26 pm

Thanks for your prompt reply

Both input and ouput files are KSDS.

Hope makes it clear

superk · Posted: Fri Dec 22, 2006 6:26 pm

Are they fixed-length or variable-length records?

Your terminology is a bit confusing. First, you say you want to merge the two VSAM files, which would mean that each file is in a proper sorted order, but then you say that you used SORT FIELDS=COPY, not MERGE FIELDS=(p,l,BI,A).

The most likely method to try is to copy each VSAM file to a single sequential file, then sort the sequential file into the proper key order, and then copy the sequential file to the output VSAM file.

rajandhla · Posted: Fri Dec 22, 2006 6:31 pm

Thanks for posting reply..

If both the files are in sorted order and if i use the option

SORT FIELDS=MERGE will it work. Pressuming both the input files are

VSAM ksds files and output file is also KSDS file.

Please let me know ..

cheers..

rajandhla · Posted: Fri Dec 22, 2006 6:33 pm

I have missed answering one question ..

All files are variable length files...

superk · Posted: Fri Dec 22, 2006 8:55 pm