Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Difference between OUTFIL and OUTREC

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
notonly4u

New User


Joined: 26 Apr 2005
Posts: 87
Location: Hyderabad

PostPosted: Thu Jul 09, 2009 7:49 pm    Post subject: Difference between OUTFIL and OUTREC
Reply with quote

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
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Jul 09, 2009 8:48 pm    Post subject:
Reply with quote

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:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA30/1.5.4?DT=20080528171007#FIGSTMTSEQ
Back to top
View user's profile Send private message
Douglas Wilder

Active User


Joined: 28 Nov 2006
Posts: 305
Location: Deerfield IL

PostPosted: Thu Jul 09, 2009 8:54 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts WER268A OUTREC STATEMENT : SYNTAX E... frozenblood87 SYNCSORT 12 Sat Aug 26, 2017 9:45 pm
No new posts outrec field outside range Danielle.Filteau SYNCSORT 10 Sat Mar 04, 2017 2:37 am
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us