IBM Mainframe Forum

Hi,
I have esds file1:
10 10000
11 50000
12 40000
13 90000

another esds file2:
16 10000
18 90000
20 40000
21 26000

I want output esds file like:
10 10000
16 10000
11 50000
12 40000
20 40000
13 90000
18 90000
21 26000

the second field is repeating and i want the same field to come one after in the output file.
Can anyone tell me how i can sort these record using sot/icetool utility keeping second duplicate field in sequence.
In the above example the first field is non repeating even if the second fields gets duplicates in second file.
the ascending or descending sequence is not important.

Hello and welcome to the forum,

Your output appears to be in no sequence at all. . .

Please more clearly explain the "rules".

Why can you not simply concatenate the 2 input files and sort on the second field?

Thanks for the quick reply..
when I am trying to sort using sort utility on second field I am getting error like: "OUT OF SEQ" with maxcc 16.
Is it because of duplicates..when i tried with no duplicates it works fine..but my requirement is for second duplicate field to be in sequence.
In the previous example sequence in not important I mean I just want to have second field similar record one after another..if there is no duplication of second field then that record may appear before or after the bunch of repeated one.

Hello,

when I am trying to sort using sort utility on second field I am getting error like: "OUT OF SEQ" with maxcc 16.

Post the jcl, control statements, and the complete diagnostic information generated when the job was run.

Hi,

My JCL is:



at 24 second fiels gets start having length 10

Following is the error:
WER068A OUT OF SEQ SORTIN01 , BLOCK 2
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000

My file sortin01 file is similar wih differnt data which i shown in the above example.

I tried another approach which works fine:
1) in first step: I merged the 2 files on 1st field which is having no duplication
2) in second step: I sort the merged file on second field which is having duplication with control statement shown above with sort field.

But I am wondered why its not doing sorting and merging in one go with 2nd field as control.

Hello,

Using 2 steps is not a "works fine". Using 2 steps and multiple passes of the data just wastes system resources.

When using MERGE the files should already be in sequence by the key(s).

Suggest you now run what i suggested earlier - concatenate both input files into a sort(not a merge) and you will get what you want with only one pass of the input, only 1 setp of jcl and dd statements to maintain, and the output will "grouped" by the second field.

Hi,
When I am concatenating both vsam files , error which i got is: concatenation is not allowed in VSAM,
Can u please suggest the code which can help me to resolve the problem.

Sorry - i forgot about the files being vsam. . .

You could sort both files separately and then merge them or you might COPY them to sequential files and sort them at the same time using concatenation for the qsam files.

Savita,

We can help you out. Please contact me offline at alissa.margulies@syncsort.com in regards to concatenating VSAM files.

Regards,