Page 1 of 1

Sorting multiple VSAM files

PostPosted: Wed Nov 06, 2013 10:09 pm
by ibmmf4u
Hi All,

I have four VSAM files which are identical in terms of allocation and attributes. I want to sort all these VSAM files into a single flat file, basically just concatenating all the VSAM files.

I did look at several sites before posting it and tried out several things , nothing did work.

SORTIN DD DSN=VSAM1.FILE, DISP=SHR
            DD DSN=VSAM2.FILE,DISP=SHR
            DD DSN=VSAM3.FILE,DISP=SHR
            DD DSN=VSAM4.FILE,DISP=SHR
SORTOUT DD DSN=FLAT.FILE,DISP=SHR


I did try using
SORTIN01,SORTIN02,SORTIN03..
for multiple input VSAM files and got error message stating SORTIN statement missing.

Request someone to kindly help me out.

Thanks,

Re: Sorting multiple VSAM files

PostPosted: Wed Nov 06, 2013 10:23 pm
by BillyBoyo
What version of SyncSort do you have?

Re: Sorting multiple VSAM files

PostPosted: Wed Nov 06, 2013 10:42 pm
by ibmmf4u
We have SYNCSORT 1.4.1.0R at our site.

Re: Sorting multiple VSAM files

PostPosted: Wed Nov 06, 2013 10:48 pm
by Akatsukami

Re: Sorting multiple VSAM files

PostPosted: Wed Nov 06, 2013 10:55 pm
by ibmmf4u
Thank you Akatsukami. so it does signify that we can't concatenate multiple VSAM datasets.

Re: Sorting multiple VSAM files

PostPosted: Wed Nov 06, 2013 10:57 pm
by c62ap90
There is a "space" before DISP. That won't work.
SORTIN DD DSN=VSAM1.FILE, DISP=SHR

Re: Sorting multiple VSAM files

PostPosted: Wed Nov 06, 2013 11:04 pm
by Akatsukami
ibmmf4u wrote:Thank you Akatsukami. so it does signify that we can't concatenate multiple VSAM datasets.

That is so, although you can do a pseudo-concatenation through Syncsort by using MULTIIN.