Focal Point
files

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3931019331

November 09, 2005, 02:49 PM
<lumen>
files
Hi

I want to compare two sequential files and write the output to a third file.Could anyone help to do this in focus.

cheers
lumen
November 09, 2005, 04:16 PM
Noreen Redden
Sure, MATCH FILE will do it, but what are you trying to accomplish. Is there a quasi key that we can compare or are you only syaing are they an exact match. If that's so, then there might be other utilities that would be better. ARe you trying to get out a report of only the mis-matches, etc.
November 16, 2005, 03:51 AM
<lumen>
quote:
I was using MODIFY.But it is not working.The aim is to compare two files on a particular key.If the condition satifies the records should be written to a third file and upadte a field in the third file.

November 16, 2005, 10:47 AM
k.lane
There are a few ways to do what you are trying to do. One such method is to use both MATCH and MODIFY. You could use match to compare both files (assuming of course that you have masters describing both files) and then HOLD FORMAT ALPHA.

Using this HOLD file, you could then issue the MODIFY with a FIXFORM to load a third file and update the field as required.

Of course, this all depends on what you are trying to do. What type of condition are you checking? What are you updating in the third file based on the matched records? Are the records of interest in both of the first and second files? What happens if a record doesn't match? Is it tossed?

Ken

This message has been edited. Last edited by: k.lane,


Prod - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Dev - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Databases: Oracle 10g, SQL Server 2000, DB2.