Printing the empty files using Icetool

deeptik · New User Joined: 21 Mar 2006 Posts: 8

Hi,

I have been given a set of 25 files. I need to check all of the files to see if they are empty. At the end I need to print a report listing the names of all Empty files.

I want to do this using DFSORT/ICETOOL. The empty file check can be done using the COUNT operator. It is possible to print the report containing the names of all empty files too but this process on the whole would require as many steps as the number of files. I want to know if there is any other way by which this can be done using DFSORT/ICETOOL in the minimum number of steps.

Thanks

Escapa · Posted: Mon Aug 31, 2009 4:38 pm

Use REXX

expat · Posted: Mon Aug 31, 2009 5:03 pm

Yes, you can definitely do it in one REXX step.

Read in the list of datasets to be checked, create a loop to use IDCAMS PRINT COUNT(1) for each dataset, and if RC=4 it is empty, so print out the name of the empty dataset.