comparing more than 2 files using ICETOOL

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

Hi all,

I have three different input files, where i need to compare them based on the key field at appropriate position and get 2 output files (matching and non-matching records). The key field is present in the same position in all the three files.

hchinnam · New User Joined: 18 Oct 2006 Posts: 73

I assume by matching records you mean records that are present in all the three files. I also assume in the ouput you need only one record per key.

If so your splice shouls look like this

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

Kolusu,
Here is the information you asked for:

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.

Output File2 : Should contain all the matching records from 3 files.

Example:
--------

File1: File2: File3:
----- ------ ------
AAA BBB 100 DDD AAA BBB 100 DDD AAA BBB 100 DDD
EEE FFF 200 ccc CCC FFF 600 EEE CCC FFF 200 GGG
DDD NNN 300 AAA XXX jjj 400 VVV EEE JJJ 500 KKK
zzz NNN 300 AAA zzz NNN 300 AAA

Output File1: Output File2:
-------------- -------------
DDD NNN 300 AAA AAA BBB 100 DDD
zzz NNN 300 AAA

Thanks in advance

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

Hey,
Sorry for the improper format of example.Please find it below:

File1:
-----
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
XXX jjj 400 VVV
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

Thanks