Ron, Following the other Gus why good and bad ? Are bad needed ? If so archived , like John spoke about using DB2 or IMS or ?
Scott ford www.identityforge.com Tell me and I'll forget; show me and I may remember; involve me and I'll understand. - Chinese Proverb On Nov 20, 2012, at 11:57 AM, Ron Thomas <[email protected]> wrote: > 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 ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
