Hello. We have a input file with the below format
Date Bad Custno Good Cust No 01/01/2012 989898 12345 02/02/2012 12346567 9898790 03/04/2012 676767 767689 This file is a sequentail file wil get appended on a daly basis , i.e they will be inputting a bad customer number and a good customer number. The customer numbers are used in around 20 tables and because of some typo errors or any other thing the bad customer numbers got entered in to the tables. We need to correct the same on a daily or weekly process. could some one throws some light on what should be the best process we should consider here. The customer numbers are primary keys in many of the tables. Thanks in Advance Regards Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
