For comparison of files which utility is best

dick scherrer · Posted: Mon Sep 22, 2008 6:27 am Post subject:

Hello,

obulisankar · New User Joined: 03 May 2007 Posts: 20 Location: bangalore

Frank,

I'm new to ICEMAN, My intention is to compare two or more files using ICEMAN (the constraint is only one temporary file should be used).

Below is the information:

LRECL --> 160
RECFM --> FB
Volume of records --> will be in millions
No. of duplicates --> keep varying
No. of keys used for comparision --> 1
Lenghth of key field --> 10
Position of Key --> 147

The DCB properties are same for all the input and output files.

I have 3 files: File1 , File2 , File3 . All of these files contain the records of the same type.

I need to compare these 3 files and get 2 output files.

Output File1 : Should contain the matching records from File1 and File2 and non-matching records from File3. [(File1 & File2) - File3]

Output File2 : Should contain all the matching records from 3 files.
[File1 & File2 & File3]

Example:
--------

File1:
-----
AAA BBB 100 DDD
AAA BBB 100 DDD
EEE FFF 200 CCC
DDD NNN 300 AAA
ZZZ NNN 300 AAA

File2:
------
AAA BBB 100 DDD
CCC FFF 600 EEE
DDD NNN 300 AAA
ZZZ NNN 300 AAA

File3:
------
AAA BBB 100 DDD
CCC FFF 200 GGG
EEE JJJ 500 KKK

Output File1:
--------------
DDD NNN 300 AAA
ZZZ NNN 300 AAA

Output File2:
-------------
AAA BBB 100 DDD
AAA BBB 100 DDD

Thanks in advance

dick scherrer · Posted: Mon Sep 22, 2008 7:42 pm Post subject:

Hello,

Is there some reason you posted all of this again?

When you asked last week, you were given an answer from a DFSORT developer:

Frank Yaeger · Posted: Mon Sep 22, 2008 9:04 pm Post subject:

PGM=ICEMAN and PGM=SORT are identical - both invoke DFSORT. Read my previous comments as "If you're talking about PGM=ICEMAN or PGM=SORT (DFSORT) ...".