IBM Mainframe Forum

Hi guys,

Is there an easy/quick way to use ICETOOL to get a count of the number of records in a file that meet a given criteria. Note: This is on my 38 million record file.

eg.

AAAA20080101
BBBB20080201
CCCC20080301
CCCC20080315
DDDD20080331
EEEE20080401

I need to know the number of records where the value of the field at positions 5 to 12 is >= 20080301 and <= 20080331 (inclusive). In this example the count would be 3.

The data is currently sorted by the first 4 bytes.

Cheers,
Aaron

If you just want the count in a message, you can use a DFSORT/ICETOOL job like this:



The count will be displayed in //TOOLMSG as follows:



If you want something else, be more specific about what you want.

Thanks Frank, that is exactly what I am after.

Cheers,
Aaron

How can I write the count to a datset? I want to perform multiple counts based on different conditions on the same input file. It would be easier to work with the results if they were written to a file.

Thanks!

Hello and welceom to the forums,

How can I write the count to a datset?

If you assign the //TOOLMSG DD to a dataset rather than SYSOUT, the count (along with the other info) will be put in a dataset with no change to your sort control statements.

If you want something else, you might look at creating a trailer recor that contains the count.

How can I write the count to a datset? I want to perform multiple counts based on different conditions on the same input file. It would be easier to work with the results if they were written to a file.

You need to clarify what you mean by "perform multiple counts on different conditions". That's different then the single count the OP asked for so it would probably have a different solution.

Please show an example of your input records and what you expect for output. Explain the "rules" for getting from input to output. Give the RECFM and LRECL of your input file. Give the starting position, length and format of each relevant field.