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
how to calculate the file size
Moderators: chulett, rschirm, roy
how to calculate the file size
Pranay
Seatte, WA
Seatte, WA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.