MVSFORUMS.com

[bprasanna]

Hi,
We have a SORT step where the SORT conditon is mentioned like this.

SORT FIELDS=(1,2,CH,A,7,10,CH,A,91,250,CH,A,341,
250,CH,A,432,218,CH,A)
Note : The input file is a flat file with 650 as the LRECL.

The record is having the spaces from 17 th to 90 the positoon.

After doing the SORT,there is a EZT program which will delete the dulicate records from the SORTED output file generated.The DUPLICATES are deleted based on the total length(650).

We are planning to remove the second step which is the EZT one by introducing the SUM FIELDS=NONE option.

can we do that ?

Thanks
Bprasanna
_________________
----------------
Thanks&Regards
Bprasanna

[vivek1983]

bprasanna,

My understanding:

1. Input file is 650 in length. In the first step you are sorting based on 5 fields.
2. After sorting you are using EZT to eliminate the duplicates based on the whole record (650 bytes length).
3. You need to know if the second step (EZT) can be eliminated using SYNCSORT.


If my understanding is correct then try my below suggestion:

1. First step, sort the file based on the whole length:

SORT FIELDS=(1,650,CH,A)
SUM FIELDS=NONE

2. In the second step include your sort card(based on 5 fields) to the output of the first step.

I guess you will get the desired results.

Hope I am not missing something.
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay)

[bade_miya]

Hi Prasanna,

Shouldnt you be droping the duplicates first using the sortcard mentioned by vivek above and then do the sorting with whatever records left in the file.

bade_miya

[Terry_Heinze]

Bprasanna,
Do you realize that sort fields 4 and 5 overlap and did you intend to leave out position 650 while sorting or is that a typo?
_________________
....Terry

[amargulies]

bprasanna,

Also, what happened to position 3-6? Are those blank also?
_________________
Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com