Record Count

[kogads]

Hi All,
I am extracting files for a directory using a file pattern using sequential file. I need to perform audit check as well for all the files. Each file has record count as a part of its name. Ex. test1.R3000. This test1 file has 3000 records. I need to abort the job if the record count fail. As iam extracting using file pattern how can I reject the file that does not pass the audit check and extract remaining files.

Thanks in advance

[ray.wurlod]

Lots of ways. Probably the easiest is a Routine activity to verify the row count in the file against the file name.

[Sainath.Srinivasan]

You can do a

Code: Select all

wc -l yourFilePattern

and compare the line counts

[chulett]

When does this 'abort' need to happen? Any check like that can be made well before it ever hits a DataStage job, if that's what you need. Or you could count it first, pass that count to the job and have it validate that count as part of its processing... usually involving an Aggregator doing the counting.