Hi All, After going through this topic dfsort-icetool-icegener/topic7678.html i developed a doubt, whether the operation given in the control card executes first and upon which the toolin operation works or is it otherwise. Or it depends of the operations specified in the toolin dd?
SELECT calls DFSORT to sort the records according to the ON fields. If you override the SORT statement used for the DFSORT call(as shown in the other topic you linked), DFSORT uses that SORT statement. The Parms FIRST, LAST, ALLDUPS... are evalauted in the last phase using the ON fields after sorting the data has been completed.