SORT FIELDS=COPY
JOINKEYS FILE=F1,FIELDS=(371,08,A,92,10,A,37,10,A)
JOINKEYS FILE=F2,FIELDS=(29,8,A,37,10,A,47,10,A)
JOIN UNPAIRED,F1
REFORMAT FIELDS=(F1:01,389,F2:01,28,?),FILL=C'?'
OUTFIL FNAMES=SALIDA1,
INCLUDE=(418,1,CH,EQ,C'B',AND,31,1,CH,EQ,C'X'),
BUILD=(001,389,C'REL',390,28,47,3)
OUTFIL FNAMES=SALIDA2,
INCLUDE=((418,1,SS,EQ,C'1B',AND,31,1,CH,NE,C'X'),OR,
(418,1,CH,EQ,C'1',AND,31,1,CH,EQ,C'X')),
BUILD=(001,389,C'REL',371,08,92,10,37,10,47,3)
END
JOINKEYS FILE=F1,FIELDS=(371,08,A,92,10,A,37,10,A)
JOINKEYS FILE=F2,FIELDS=(29,8,A,37,10,A,47,10,A)
JOIN UNPAIRED,F1
REFORMAT FIELDS=(F1:01,389,F2:01,28,?),FILL=C'?'
OUTFIL FNAMES=SALIDA1,
INCLUDE=(418,1,CH,EQ,C'B',AND,31,1,CH,EQ,C'X'),
BUILD=(001,389,C'REL',390,28,47,3)
OUTFIL FNAMES=SALIDA2,
INCLUDE=((418,1,SS,EQ,C'1B',AND,31,1,CH,NE,C'X'),OR,
(418,1,CH,EQ,C'1',AND,31,1,CH,EQ,C'X')),
BUILD=(001,389,C'REL',371,08,92,10,37,10,47,3)
END
It work very well but the problem is that the sort take about 30 minutes to end.
The files aren't sorted by the keys and each one has over 60 millions of records.
Any Idea to optimize the sort in order to improve the efficiency? it is possible?
Thanks.
