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

Getting output records in SORTOUT even with empty input


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

Active User


Joined: 11 Apr 2005
Posts: 106
Location: Cincinnati Ohio

PostPosted: Fri Sep 22, 2006 12:10 am
Reply with quote

Hi all,

I am using the below sort card in one the steps in JCL.

SORT FIELDS=(1,10,CH,A)
OUTFIL REMOVECC,NODETAIL,
SECTIONS=(1,10,
TRAILER3=(1,10,X,COUNT=(M11,LENGTH=9)))

Its working fine when there are some records in Input but its giving one output record even when the input file is empty.

Output record

000000000
(Nine zeros at the position of count) Where as I would like to have the output as empty in above case.

I am new to SORT and would appreciate help on this.

-thanks
David P.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


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

PostPosted: Fri Sep 22, 2006 1:09 am
Reply with quote

TRAILER3 is supposed to write a record even when the input file is empty.

You can easily eliminate that record when the count is all 0's with a DFSORT/ICETOOL job like this:

Code:

//S1    EXEC  PGM=ICETOOL
//TOOLMSG   DD  SYSOUT=*
//DFSMSG    DD  SYSOUT=*
//IN DD DSN=... input file
//T1 DD DSN=&&T1,UNIT=SYSDA,SPACE=(CYL,(5,5)),DISP=(,PASS)
//OUT DD DSN=...  output file
//TOOLIN   DD    *
SORT FROM(IN) USING(CTL1)
COPY FROM(T1) TO(OUT) USING(CTL2)
/*
//CTL1CNTL DD *
  SORT FIELDS=(1,10,CH,A)
  OUTFIL FNAMES=T1,REMOVECC,NODETAIL,
    SECTIONS=(1,10,
    TRAILER3=(1,10,X,COUNT=(M11,LENGTH=9)))
/*
//CTL2CNTL DD *
  OMIT COND=(12,9,ZD,EQ,+0)
/*
Back to top
View user's profile Send private message
David P

Active User


Joined: 11 Apr 2005
Posts: 106
Location: Cincinnati Ohio

PostPosted: Fri Sep 22, 2006 1:14 am
Reply with quote

Thanks Frank for your quick response.

-David P.
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 Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Joinkeys - 5 output files DFSORT/ICETOOL 7
Search our Forums:

Back to Top