how to calculate the file size

pranay · Post by **pranay** » Wed Sep 03, 2008 7:53 pm

Hi All,
I have to create a audit file with the following details in xml format.
filename, file size, number of recs.
how can i know these details without using unix.
is there a way for this or have to do with unix only.

Regards,
Pranay

ray.wurlod · Post by **ray.wurlod** » Wed Sep 03, 2008 8:36 pm

You can count the lines and total the lengths as the row passes through your ETL design, aggregate these as required and create a new row for each in your audit table. Writing to the audit table impresses as a great opportunity to use a shared container, in which the audit columns such as job name, job start timestamp, etc., can be added.