Hello,
I have been asked to find how can I erase the Bad Records(dirty data) from Proisam File? Cos I donīt wanna lose the 419 record on this file.
If I try to make some Report, Update or Screen function thereīs always come this msg: "Data Not Numeric in File"
In a 1 week ago this file was working just fine but unfortunately something wrong happen yesterday. Am tryng to find out WTH happen to this file... someone can help me?
Thanks
Dirty Data
Started by Fotini Informatica, Oct 20 2008 04:41 PM
1 reply to this topic
#2
Posted 20 October 2008 - 05:59 PM
Dirty Data,
I would create a maintenance screen for the file, scroll through the individual records. When the bad data record appears, you'll know which record is bad. Delete it, or fix it, and be on your way.
Another thing you could try is to write an update that will back up File1 to File2, with a commit after each AWNE. When it fails, you'll know the record before the bad data record. Insert a counter and then rerun it. This time, though, DSEL the addition of this bad File1 record into File2. When File2 has all good records, recreate File1, which will erase everything, then reverse the copy update used to copy File1 to File2, so that it now copies File2 to File1. When all is said and done, you should only have good records.
HTH,
AK
I would create a maintenance screen for the file, scroll through the individual records. When the bad data record appears, you'll know which record is bad. Delete it, or fix it, and be on your way.
Another thing you could try is to write an update that will back up File1 to File2, with a commit after each AWNE. When it fails, you'll know the record before the bad data record. Insert a counter and then rerun it. This time, though, DSEL the addition of this bad File1 record into File2. When File2 has all good records, recreate File1, which will erase everything, then reverse the copy update used to copy File1 to File2, so that it now copies File2 to File1. When all is said and done, you should only have good records.
HTH,
AK
THE LIGHT AT THE END OF THE TUNNEL IS THE HEADLAMP OF THE TRAIN THAT'S ABOUT TO HIT YOU!!!
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users