Formatted Diff (File Compare)

Formatted Diff (File Compare)

This program is a compare for Flat (Fixed Width / CSV) data files. Main features include

1. Only the data is compared, so files in completely different formats (say mainframe Binary Cobol to PC CSV file) can be compared.
2. Only the fields you select to be compared are Compared.
3. Data is displayed as seperate fields

Installing

• You must install version 0.62 of the RecordEditor.
• Copy the files diff.jar, diff.bat/diff.sh to the lib directory of your RecordEditor instalation.
• For the generic version; you must update bat/shell script to include the JDBC jar you are using. i.e.

    Change hsqldbmain.jar to your JDBC jar (say xxx.jar)
   
              javaw -cp properties.zip;diff.jar;hsqldbmain.jar
        to
              javaw -cp properties.zip;diff.jar;xxx.jar
  

Note: This compare program will come as standard with version 0.65 of the RecordEditor

Note: This will not update any part of version 0.62, it a seperate program.

Diff Program

When you start the diff program, a menu is displayed with 3 options:

1. Run stored Compare. Allows you to rerun a previously setup compare.
2. Compare Single Layout. This is used to compare to files in the same format (i.e. uses the same Record Layout).
3. Compare Different Layouts. This is used to compare the data in two

Compare (Single Layout)

The first screen lets you enter the 2 files to be compared + the record layout to be used.

The next screen lets you select which Records / Fields are to be compared

The next screen lets you:

• Save the compare options to an external file (as XML). This file can be rerun in compare option 1.
• Run the compare and show the results on the screen.
• Enter HTML options (i.e. enter HTML file name etc).
• Run the compare and write the results to a HTML file.

If you run the option online; the first screen list all differences in a single table. You can switch between displaying all / changed lines using the button on the top right of the screen.

You can select a single line display by clicking on the button on the left hand side of the screen.

See Cmp_amsPo_1.html for a sample HTML compare

Note: Green means changed line, Blue is for deleted line and Yellow is for inserted line.

If you select a single line display, you will get (click the left most column of the screen above):

Compare (Two Layout)

When comparing files in different formats (i.e. 2 different layouts), select option 3 from the compare main menu. The files can be quite different formats. One could be native mainframe Binary file and the other a PC CSV file. It the data in the fields that is compared.

The first 2 screens look like the following and you enter the 2 files and there record layouts.

Following is the field selection where you match the fields up:

The next screen lets you:

• Save the compare options to an external file (as XML). This file can be rerun in compare option 1.

• Run the compare and show the results on the screen.

• Enter HTML options (i.e. enter HTML file name etc).

• Run the compare and write the results to a HTML file.