Sorting multiple VSAM files



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Sorting multiple VSAM files

Postby ibmmf4u » Wed Nov 06, 2013 10:09 pm

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,
ibmmf4u
 
Posts: 65
Joined: Wed Dec 14, 2011 10:26 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Sorting multiple VSAM files

 

Re: Sorting multiple VSAM files

Postby BillyBoyo » Wed Nov 06, 2013 10:23 pm

What version of SyncSort do you have?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Sorting multiple VSAM files

Postby ibmmf4u » Wed Nov 06, 2013 10:42 pm

We have SYNCSORT 1.4.1.0R at our site.
ibmmf4u
 
Posts: 65
Joined: Wed Dec 14, 2011 10:26 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Sorting multiple VSAM files

Postby Akatsukami » Wed Nov 06, 2013 10:48 pm

"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: Sorting multiple VSAM files

Postby ibmmf4u » Wed Nov 06, 2013 10:55 pm

Thank you Akatsukami. so it does signify that we can't concatenate multiple VSAM datasets.
ibmmf4u
 
Posts: 65
Joined: Wed Dec 14, 2011 10:26 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Sorting multiple VSAM files

Postby c62ap90 » Wed Nov 06, 2013 10:57 pm

There is a "space" before DISP. That won't work.
SORTIN DD DSN=VSAM1.FILE, DISP=SHR
c62ap90
 
Posts: 125
Joined: Thu Oct 11, 2012 10:24 pm
Has thanked: 1 time
Been thanked: 6 times

Re: Sorting multiple VSAM files

Postby Akatsukami » Wed Nov 06, 2013 11:04 pm

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.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post