hierarchy of operation?



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

hierarchy of operation?

Postby gokulNmf » Mon Jun 04, 2012 10:21 pm

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,
Cheers,
Gokul
User avatar
gokulNmf
 
Posts: 118
Joined: Sat Mar 28, 2009 6:41 pm
Location: India
Has thanked: 2 times
Been thanked: 0 time

Re: hierarchy of operation?

Postby skolusu » Mon Jun 04, 2012 10:33 pm

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.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: hierarchy of operation?

Postby gokulNmf » Tue Jun 05, 2012 10:41 am

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?
Cheers,
Gokul
User avatar
gokulNmf
 
Posts: 118
Joined: Sat Mar 28, 2009 6:41 pm
Location: India
Has thanked: 2 times
Been thanked: 0 time

Re: hierarchy of operation?

Postby skolusu » Tue Jun 05, 2012 9:27 pm

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.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post