IBM Mainframe Forum

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?


Thanks in Advance,

gokulnmf,

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.

Hope this clarifies your question.

Hi skolusu,

So if we are coding the USING clause then first the SORT operation in the USING:control statement is performed and after that the ICETOOL operation is performed on it.

Is my understanding correct?

gokulNmf wrote:Hi skolusu,

So if we are coding the USING clause then first the SORT operation in the USING:control statement is performed and after that the ICETOOL operation is performed on it.

Is my understanding correct?

You need to follow the diagram shown here.

http://publibz.boulder.ibm.com/cgi-bin/ ... 0608113434

The operators SPLICE, SELECT, RESIZE, DATASORT, SUBSET.. operators are performed in the OUTREC phase.