I have an indexed flatfile database (Acucobol) that I have unloaded to a text file with one 40 byte record per line (0A 0D delimited). Each record begins with an 8 byte unique key. The file is sorted on this key.
My requirement is to read through the file and identify any missing records based on this key, and to write the resulting key to a result file.
The unload file contains nearly 4,000,000 records of the following format:
00000022ACCOUNT120060808010001 <- Record ends here, at column 40>
Where a field in a record is incomplete the data is replaced with spaces (or, occasionally with nulls).
Any help would be appreciated.
My thoughts would be to read through the file examining the first 8 bytes to a value (beginning with 00000000), and adding 1 at each iteration. If the comparison is true continue, if false write the comparison string to the result file and continue. I currently have the latest and greatest Uedit32 installed.