![Smile :)](./images/smilies/icon_smile.gif)
How can I update certain columns in a sequential file with data from another sequential file.
For example, the main sequential file would look something like this:
LoanNo, ZipCo, State, Int, Sfee, balance
456124, 21788, PA, 7.1250, .0250, 75000.00
333120, 55151, CA, 6.7580, .0250, 99000.00
122115, 31030, MD, 7.0000, .0250, 34000.00
990008, 31025, MD, 7.1250, .0250, 199000.00
The update file would look something like this:
LoanNo, Int
456124, 7.5000
In this example, only need to update colum "Int" for "LoanNo" 456124.
The main sequential file would have a LoanNo column and many other static columns. The update fiele will always have a LoanNo column and the columns with the data that need to update the main sequential file...so, the update sequential file could have one or more columns to update the main sequential file..... The update sequential file would have one or many rows.....
The "LoanNo" column will always be on both files.
Any suggestions will be appreciated!!
Thx,