MVSFORUMS.com

[puttu]

Hi All,

Could you please help me with below requirement.

Input:

I need to compare two input files. Both the Input files are in Packed decimal format and the Key for comparison is ENTIRE RECORD. We need compare with Packed decimal.

OutPut File should create as below:

1. Contains Unmatched records of both the Input Files.
2. Contains Unmatched records showing difference in particular record.
3. Contains records which are present in File1 but not in File2.
4. Contains records which are present in File2 but not in File1.
5. Contains Matched records of both files.

[puttu]

Hi Kolusu,

Can you help me in above requirement.

[puttu]

Both the input file length are 80 bytes.

Five output files should create for this comparision and files should create as below
1. Contains Unmatched records of both the Input Files.
2. Contains Unmatched records showing difference in particular record.
3. Contains records which are present in File1 but not in File2.
4. Contains records which are present in File2 but not in File1.
5. Contains Matched records of both files

[William Collins]

What is the difference between 1, and 3.&4.?

How do you feel 2. should possibly work? Unless you have a key other than the whole record, you can tell it doesn't match, but you can't tell what doesn't match.

So, for 1. (which seems to cover 3. and 4.) and 5, it is a simple JOINKEYS with JOIN UNPAIRED.

If you can clarify and explain more, it may be something else.

[kolusu]

[puttu]

Hi Williams,

1 -> Output File should Contains Unmatched records of both the Input Files that is File 1 and File 2.
3 -> Output File should Contains records which are present in Input File1 but not in Input File2.
4 -> Output File should Contains records which are present in Input File2 but not in Input File1.


Regarding output file 2 i am checking the requirement again. Will let you know.

Thanks a lot.

[puttu]

Hi Kolusu,

I am sorry.

[Terry_Heinze]

[papadi]

Hi Terry,

As with Most questions like this one, the user should be required to post some sample representative data from all input files and the actual output wanted when this sample input is is processed . . .

d

[puttu]

Hi Terry,

1 -> Output File should Contains Unmatched records of both the Input Files that is File 1 and File 2.

To get above scenario output file. What I am doing is, After creating Output Files File 3 and File 4 then I am concetenating File 3 and File 4 to get Output File 1.

Below Output files for File 3 and File 4.
3 -> Output File should Contains records which are present in Input File1 but not in Input File2.

4 -> Output File should Contains records which are present in Input File2 but not in Input File1.

[papadi]

Why have you not posted some sample input/output data

di

[puttu]

Will post you