Hi All,
I need to matrch the reocrd count of the trailer and the detail records.
The trailer has the field TotalCount . But the total count has the count of header row , Detail Rows and trailer roes.
For eg ;
The header has 1 row .
The Detail has 5 rows
The tralier has 1 row.
The total count in tralier will have 7 rows.
I need to match the count with the tralier .
Please advise.
Thanks & Regards,
Kumar.R
To find record count
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Pre-process the file in an Execute Command activity executing the command wc -l filename
Read the last line of the file using tail -1 filename
Compare using test command.
Decide, on this basis, whether or not to run the job or to report a row count reconciliation error.
Read the last line of the file using tail -1 filename
Compare using test command.
Decide, on this basis, whether or not to run the job or to report a row count reconciliation error.
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.