IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

TRAILER3 is creating blank record in the output file w


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kodeesm

New User


Joined: 21 Jun 2006
Posts: 5
Location: Pune

PostPosted: Fri May 18, 2018 5:45 pm
Reply with quote

I am using DSORT tool with TRAILER3 command to convert a amount field from Character to Signed Numeric format & it works as expected. But when an empty input file is processed, an blank single record is written into output file.

Will trailer3 always create a blank record when processing an empty file? Let me know how to avoid a blank record from creation when using TRAILER3
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Fri May 18, 2018 7:15 pm
Reply with quote

After 12 years on the forum you should know not to post attachments. A simple cut and paste (with the code tags) is ample, less time consuming and less resource-consuming.
Back to top
View user's profile Send private message
kodeesm

New User


Joined: 21 Jun 2006
Posts: 5
Location: Pune

PostPosted: Fri May 18, 2018 7:26 pm
Reply with quote

My apologies for the attachement Nic Clouston. I am working on and off on mainframe projects for the last few years.

Can you share your idea how to avoid blank record while processing an empty file when TRAILER3 is present?
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2011
Location: USA

PostPosted: Sat May 19, 2018 2:56 am
Reply with quote

You can try to use
Code:
...,PARM='NULLOUT=RC4'
to indicate empty file at JCL level with step cond code 4.

I don't remember any option to completely eliminate HEADER/TRAILER records in SORT utilities, even with empty input file.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 8
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
Search our Forums:

Back to Top