explicitly mentioning sortout in outfil statement



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

explicitly mentioning sortout in outfil statement

Postby narasi_433 » Fri Apr 18, 2014 8:43 pm

Hi,
I have the following control information.

Sort fields=(4,13,CH,A)
OUTFIL FNAMES=SORTOUT
INCLUDE COND=(1,3,CH,EQ,C'102')


This sort card didnt give any error. It is working fine. Wat is the difference between this and the one without outfil statement? Both does the same thing ryt?


I havd only sortin and sortout ddnames. No other files
narasi_433
 
Posts: 6
Joined: Thu Apr 17, 2014 12:29 pm
Has thanked: 0 time
Been thanked: 0 time

Re: explicitly mentioning sortout in outfil statement

Postby skolusu » Fri Apr 18, 2014 10:01 pm

narasi_433,

If you do not specify a FNAMES or FILES parameter for an OUTFIL statement, the OUTFIL ddname is SORTOUT by default.
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: explicitly mentioning sortout in outfil statement

Postby narasi_433 » Fri Apr 18, 2014 10:10 pm

Hi,
Thanks for ur reply....... ya u r right...... if we mention it explicitly does it make any difference? Performance wise like that.......
narasi_433
 
Posts: 6
Joined: Thu Apr 17, 2014 12:29 pm
Has thanked: 0 time
Been thanked: 0 time

Re: explicitly mentioning sortout in outfil statement

Postby skolusu » Fri Apr 18, 2014 10:13 pm

narasi_433 wrote:Hi,
Thanks for ur reply....... ya u r right...... if we mention it explicitly does it make any difference? Performance wise like that.......


NO. Unless you require writing multiple files I wouldn't use OUTFIL.

Check these links which explain SORTOUT and OUTFIL processing in detail

http://publibz.boulder.ibm.com/cgi-bin/ ... e1ca60/1.7

http://publibz.boulder.ibm.com/cgi-bin/ ... 60/2.5.4.6
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: explicitly mentioning sortout in outfil statement

Postby narasi_433 » Fri Apr 18, 2014 10:23 pm

Thanks a lot
narasi_433
 
Posts: 6
Joined: Thu Apr 17, 2014 12:29 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post