record count of multiple files.

samuel_Inba · New User Joined: 03 Jan 2008 Posts: 40 Location: Chennai

The following is my requirement.

1. a job ftps around 25 input files and I need to find out the record count of each file and I need the add file name in front of the record count.

Now I have to find the number of records in "a0xxx.yyy.zzz " and write it to a seperate file with the corresponding dat names,
like - material.dat : 09382.

I know I can do this via ICETOOL but that needs to have 25 DD statements Is there any way this can be done thru a proc ?

Sam.

vel2k8

Hello,

Please use the following sort card.

SORT FIELDS=COPY
OUTFIL TRAILER1=('TEST.FILE.NAME:',COUNT=(M12,LENGTH=10)),NODETAIL

You can have a proc and pass the sort card as a parameter. But you should have 25 cards.

Thanks
Vel.

samuel_Inba · New User Joined: 03 Jan 2008 Posts: 40 Location: Chennai

hi vel,
Thnks for your reply....sorry for the delay in response...

Rgds,
Sam.