check for a particular row existing in the incoming file
Posted: Sat Aug 13, 2005 5:29 pm
The first 3 characters of each incoming record indicates the record type. Record type = '999' indicates that the record is the trailer record. At the end of each incoming file there should be a trailer record, which contains a count of the number of records in the file.
I have a transformer stage in which I want to compare the record count in the trailer record to the link count and abort if they don't match. When the file contains a trailer record I can find it and I can successfully determine if the record is correct.
The problem is when the trailer record is missing. If I don't see the trailer record in the file I also want to abort. How can I tell the transformer to abort if the end of data is reached without finding the trailer record?
I have a transformer stage in which I want to compare the record count in the trailer record to the link count and abort if they don't match. When the file contains a trailer record I can find it and I can successfully determine if the record is correct.
The problem is when the trailer record is missing. If I don't see the trailer record in the file I also want to abort. How can I tell the transformer to abort if the end of data is reached without finding the trailer record?