Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 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
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm
No new posts SORT- outrec ram_vizag DFSORT/ICETOOL 10 Tue Sep 27, 2016 12:50 am
No new posts OUTREC FILELDS FAILS WITH ICE126A 2 ... balaji81_k DFSORT/ICETOOL 8 Sat Jul 02, 2016 1:22 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us