Difference between OUTFIL and OUTREC

notonly4u · New User Joined: 26 Apr 2005 Posts: 87 Location: Hyderabad

Hi Friends,

Can anyone explain me the difference between OUTFIL and OUTREC statements?

While testing I can see that the output of

SORT FIELDS=(26,08,CH,A)
SUM FIELDS=NONE
OUTREC FIELDS=(26,8)
INCLUDE COND=(41,10,CH,EQ,C'MAINFRAMES')

is different from

SORT FIELDS=(26,08,CH,A)
SUM FIELDS=NONE
OUTFIL OUTREC=(26,8),INCLUDE=(41,10,CH,EQ,C'MAINFRAMES')

The first sort card gave 10 more records.

Thanks for your time.

Regards
Tanden

Frank Yaeger · Posted: Thu Jul 09, 2009 8:48 pm

For your first case, the functions are processed in this order:

INCLUDE
SORT/SUM
OUTREC

For your second case, the statements are executed in this order:

SORT/SUM
OUTFIL INCLUDE
OUTFIL OUTREC

The different order of processing for INCLUDE (before SORT/SUM in the first case and after SORT/SUM in the second case) is the reason for the difference in the number of output records.

See the following for complete details on the order in which DFSORT processes its various functions:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA30/1.5.4?DT=20080528171007#FIGSTMTSEQ

Douglas Wilder · Posted: Thu Jul 09, 2009 8:54 pm

In this case I believe a more efficient way would be to use INREC and INCLUDE to remove extra records and extra bytes per records before the sort.