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

Count the no. of records from a PS file


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vivek.srivastav

New User


Joined: 29 Jul 2009
Posts: 1
Location: bangalore

PostPosted: Wed Jul 29, 2009 1:27 pm
Reply with quote

Hi! i want to count the number of record of each type that are there in the PS file , suppose there are 50 records for Type A , 40 records for type B
.....and 60 for type Z.

i want a output file which will write like ..
A-50
B-40
C-40
.
.
.
.
.Z-60
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Jul 29, 2009 1:31 pm
Reply with quote

There is a search button at the top of the page, and if you had bothered to use it, you might have found THIS

The above is a DFSORT solution, but if you use SYNCSORT ........ search, or read the manuals
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Jul 29, 2009 6:09 pm
Reply with quote

Show a rather practical example of your input and expected output, here is another method I can think of on the basis of description you tell:
Code:
//STEP001  EXEC  PGM=xxxTOOL             
//TOOLMSG  DD SYSOUT=*                   
//DFSMSG   DD SYSOUT=*                   
//IN      DD *                           
A                                         
A                                         
A                                         
B                                         
B                                         
B                                         
//RPT DD SYSOUT=*                         
//TOOLIN   DD    *                       
OCCUR FROM(IN) LIST(RPT) NOHEADER BLANK -
  ON(1,3,CH) ON(VALCNT,U04)               
/*                                       
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 4
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts To get the count of rows for every 1 ... DB2 3
Search our Forums:

Back to Top