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

need to find total count for unique recods


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

New User


Joined: 12 May 2009
Posts: 5
Location: Chennai

PostPosted: Thu Oct 14, 2010 1:05 pm
Reply with quote

INPUT:

0770 8
0770 10
0551 5
1874 4
0551 3



OUTPUT:

0770 18
0551 8
1874 4

LRECL = 150, FB.

Can you please suggest options for the same via ICETOOL?
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: Thu Oct 14, 2010 11:06 pm
Reply with quote

Rajesh MS,

Here's a DFSORT/ICETOOL job that will do what I think you're asking for. If that's not what you want, you need to do a better job of explaining what it is you do want.

Code:

//S1    EXEC  PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG  DD SYSOUT=*
//IN DD DSN=...  input file (FB/150)
//OUT DD SYSOUT=*
//TOOLIN DD *
SORT FROM(IN) TO(OUT) USING(CTL1)
/*
//CTL1CNTL DD *
  SORT FIELDS=(1,4,CH,A)
  OUTFIL FNAMES=OUT,NODETAIL,REMOVECC,
    SECTIONS=(1,4,
      TRAILER3=(1,4,X,TOT=(7,5,UFF,EDIT=(IIIIT))))
/*
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 To get the count of rows for every 1 ... DB2 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Validating record count of a file is ... DFSORT/ICETOOL 13
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Find the size of a PS file before rea... COBOL Programming 13
Search our Forums:

Back to Top