Page 1 of 1

hierarchy of operation?

PostPosted: Mon Jun 04, 2012 10:21 pm
by gokulNmf
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,

Re: hierarchy of operation?

PostPosted: Mon Jun 04, 2012 10:33 pm
by skolusu
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.

Re: hierarchy of operation?

PostPosted: Tue Jun 05, 2012 10:41 am
by gokulNmf
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?

Re: hierarchy of operation?

PostPosted: Tue Jun 05, 2012 9:27 pm
by skolusu
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.