IBM Mainframe Forum

by **ranga_subham** » Mon Oct 13, 2008 10:20 pm

Hi,

I want to count number of records from a very big file based on condition.

The file has got some records with '?????' at position 727. So, I want to count only those records. How to do it? LRECL of file is 780 and RECFM is FB.

Thanks.

by **dick scherrer** » Tue Oct 14, 2008 5:13 am

Hello,

Copy the input file to an output file specified as DD DUMMY using INCLUDE to select the records you want.

The count of the copied records will be in the informatoinal output from the run.

by **ranga_subham** » Tue Oct 14, 2008 2:54 pm

Dick, as per your suggestion I could come up with the below code........ It worked and I got the results as expected.........

Select all

//STEP0002 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTOUT DD DUMMY
//SORTIN DD DSN=USERX.SECND.OUTER.BARXRAY.FISCHERS.BACKS,
// DISP=(SHR,KEEP,KEEP)
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(727,5,CH,NE,C'?????')
/*
//*

Thanks.

by **dick scherrer** » Wed Oct 15, 2008 2:42 am

You're welcome - good to hear it is working.

Thank you for letting us know

d

IBM Mainframe Forum

count no. of records based upon condition.

count no. of records based upon condition.

Re: count no. of records based upon condition.

Re: count no. of records based upon condition.

Re: count no. of records based upon condition.