i want to know the how many records are there in the file

philipraju · New User Joined: 16 Apr 2006 Posts: 29

hi,
i want to know the how many records are there in the file without opening the file and i want to know the properties of the file,let me know if possible,How (along with steps)

raghunathns · Posted: Wed May 03, 2006 6:06 am

use icetool to get the record count

niharika1234 · New User Joined: 01 May 2006 Posts: 9

Raghu !

can we use file-aid for this.......?

laxmi · New User Joined: 24 May 2005 Posts: 9

if u know the size of the file and record we can know the no of records if the record type is FB BY SIZE FO THE FILE/ SIZE OF THE RECORD.
correct me if i am wrong

priyesh.agrawal · Posted: Wed May 03, 2006 11:39 am

Search please ...there are topics available stating how to get record count of a file by a Job....One of such is here...

Regards,
Priyesh.

kousalya26 · New User Joined: 06 Jul 2005 Posts: 21 Location: chennai

As mentioned in the earlier posts, we can get the number of records in a file using a job. It can also be found using File-Aid. Use "Interactive" option in File-Aid and then give the name of the dataset on disk. Then it will ask to enter the function. Type TALLY and wait.It will give the record count.
Corrections welcome !

Thanks & Regards,
kousalya

parul · New User Joined: 08 Apr 2005 Posts: 11 Location: mumbai

yes boss..it worked..!!!