How to count no. of records based on a condition?

SyncSort's Sort Product, SyncTool for z/OS, SYNCINIT and SYNCLIST.
Post Reply
Sachin Kumar
Registered Member
Posts: 24
Joined: Wed Jul 17, 2013 9:08 am

How to count no. of records based on a condition?

Post by Sachin Kumar »

Hi,

I want to count number of records from a huge file based on condition. The file has got some records with, say 'AAAAA' at position 10. I want to count only those records. How to do it? LRECL of file is 80 and RECFM is FB.
User avatar
Robert Sample
Global Moderator
Global Moderator
Posts: 1895
Joined: Fri Jun 28, 2013 1:22 am
Location: Dubuque Iowa
United States of America

Re: How to count no. of records based on a condition?

Post by Robert Sample »

1. Use Sort to an output dummy file and manually look at the sort output count.
2. Use SAS or EASYTRIEVE if installed at your site
3. Write a program in the language of your choice

There are other ways depending upon the specifics of the file and the site, but three should give you a way to proceed.
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “SyncSort, SyncTool, SyncGener.”