using icetool to check for empty file.

newbie · New User Joined: 05 Nov 2005 Posts: 8

Hi.

Is there a way to use icetool to check to see if a file is empty or not. If the file is not empty, then i want to do skip some of the records and copy a certain number of records. I would like to do all this in one step.

For example.

If file1 is empty
set return code to 04
else
skip(20000) count(30000) to file2
end-if.

Thank you.

Frank Yaeger · Posted: Sat Nov 05, 2005 1:50 am Post subject:

You can use the following DFSORT/ICETOOL job for this kind of thing:

newbie · New User Joined: 05 Nov 2005 Posts: 8

This work perfectly. I wish the RC can be set to 4. So that way my JCL will show RC4 instead of RC12. But this will do for now.

Thank you for the quick response. I really appreciate this.

Frank Yaeger · Posted: Sat Nov 05, 2005 3:41 am Post subject:

If you want RC=4 instead of RC=12, you can use two steps instead of one step. The first step would have the COUNT operator with RC4. The second step would have the COPY operator. You could use JCL checking (e.g. IF) in the second step to decide whether to run or bypass the step based on the RC=0 or RC=4 from the first step.

newbie · New User Joined: 05 Nov 2005 Posts: 8

Thanks Frank. That's exactly what I'm going to do. I'm going to use Icetool to check for the empty file. If not empty, then I will use IDCAMS to do the copy.