MVSFORUMS.com

jeet007 · Beginner Joined: 16 Sep 2005 Posts: 1 Topics: 1

I need to sort a particular file on three of it's fields using SYNCSORT. Those three fields may have the same values for a set of records. In the sort result the records that have the same values in the Sort fields are not retaining the sequence as in the Input file.
If I don't use the SORTWK parameter in the JCL the order is maintained but I cannot do away with the SORTWK parameter as the input file may be quite large.

Mervyn · Posted: Fri Sep 16, 2005 8:24 am Post subject:

Jeet007,

This should be in the Utilities forum.

I don't know SYNCSORT that well, but DFSORT will handle this if you specify the EQUALS parameter, and I expect SYNCSORT will too.

Also, I think your input file has to be extremely large before you actually need SORTWK.
_________________
The day you stop learning the dinosaur becomes extinct

kolusu · Posted: Fri Sep 16, 2005 8:26 am Post subject:

Jeet07,

Did you read the rules to post in this forum ? Please do not post questions seeking help in this forum.

Check this link for the rules of posting in this forum.

I am moving your question to Utilities forum.

You need to use OPTION EQUALS. EQUALS guarantees that the first of a series of equal-keyed records is either first-in (SORT) or from the lowest numbered SORTINnn data set(MERGE). With NOEQUALS, there is a random element to the order in which records with identical control fields will appear in the output. With or without EQUALS, MERGE preserves the order of equal-keyed records within any one data set.

Phantom · Posted: Sat Sep 17, 2005 12:15 am Post subject:

Jeet07,