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

Displaying count for invidual sections


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

New User


Joined: 11 Jan 2007
Posts: 52
Location: chennai

PostPosted: Fri Apr 20, 2007 2:51 pm
Reply with quote

Hi ,

Now i have written code to display a section report based on first 2 character. i want to prinf the nomber of records for each section. how to do that, the code i am using to display is as below.

Code:
//TOOLIN DD *                         
DISPLAY FROM(IN) LIST(SECTIONS)-       
HEADER('M') ON(3,3,CH)-               
BTITLE('S') BREAK(1,2,CH)-             
/*   


Regards,
Mani
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 Apr 20, 2007 8:08 pm
Reply with quote

DISPLAY doesn't have a COUNT function, but OUTFIL does, so you can use this DFSORT job to do what you want:

Code:

//S1    EXEC  PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=...  input file
//SECTIONS DD SYSOUT=*
//SYSIN DD *
  OPTION COPY
  OUTFIL FNAMES=SECTIONS,
   BUILD=(3,3,120:X),
   SECTIONS=(1,2,SKIP=P,
    HEADER3=('S',2X,1,2,/,X,/,'M',/,'--------------------'),
    TRAILER3=('COUNT IS ',COUNT=(M10,LENGTH=5)))
/*
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 IBM OnDemand Folders displaying to al... IBM Tools 6
No new posts getting subtotals for multiple sections SYNCSORT 4
Search our Forums:

Back to Top