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
 

 

OVERLAY and IFTRAIL

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

Active User


Joined: 29 Oct 2010
Posts: 183
Location: Toronto, ON, Canada

PostPosted: Tue Jul 08, 2014 11:56 pm    Post subject: OVERLAY and IFTRAIL
Reply with quote

I stumbled on something in DFSORT that could be considered a feature or a bug. In my case it was a feature since it gave me what I wanted.

Below are the sort statements. Notice the use of both OVERLAY and IFTRAIL
Code:

SORT FIELDS=COPY

OUTFIL FNAMES=INSERT,
  OVERLAY=(24:C'I'),                 
   IFTRAIL=(TRLID=(1,3,CH,EQ,C'TRL'),
            TRLUPD=(12:COUNT=(M11,LENGTH=11)),HD=YES)

This does not overlay the first (header) and last (trailer) records in the output. If I remove "HD=YES" then it updates the header record. If I remove the entire IFTRAIL then it overlays all records.

I did not see anything in the manual that states this as the expected result. The OVERLAY should have udpated all records. So is this a feature or a bug?
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7306

PostPosted: Wed Jul 09, 2014 5:17 am    Post subject: Reply to: OVERLAY and IFTRAIL
Reply with quote

From the manual:

Quote:
The trailer record will NOT be treated as a data record, that is, no other OUTFIL processing will be performed against the trailer record. You can optionally specify that the header (first) record will NOT be treated as a data record.


Not a feature, but working as designed and described.
Back to top
View user's profile Send private message
jerryte

Active User


Joined: 29 Oct 2010
Posts: 183
Location: Toronto, ON, Canada

PostPosted: Mon Jul 28, 2014 10:06 pm    Post subject:
Reply with quote

The DFSORT manual has 173 pages to describe the operation of the OUTFIL statement. About 3.5 pages cover the IFTRAIL. I missed the 2 sentences buried in the middle to state the header and trailer records are kept as is. It seems to function similiar to the icetool DATASORT in how it treats the header/trailer.
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 Overlay the system date Danielle.Filteau SYNCSORT 4 Fri Mar 03, 2017 1:16 am
No new posts Overlay with right shift Bill Woodger DFSORT/ICETOOL 3 Thu Jan 28, 2016 7:49 pm
No new posts Overlay with WHEN=Group not working krsenthil85 DFSORT/ICETOOL 7 Wed Oct 21, 2015 4:00 am
No new posts Merge two files with some replace/ove... dheeraj.ramchandani DFSORT/ICETOOL 10 Thu Sep 03, 2015 7:59 pm
No new posts OVERLAY several fields if non-blank autobox DFSORT/ICETOOL 5 Fri Jul 10, 2015 12:42 pm


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