How to retain duplicates in the o/p file using SPLICE opertr

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

Hi All,

I have two Input files both having same record length of 160. The common keys on which ICETOOL should compare these two files are not located in same column positions (i.e., On 1st file it is from 147 - 148 and on the second fil it is from 1 - 2). After comparison I want the matching records to be in one file and non matching records to be in other file. I also want to retain the duplicates of both matching and non-matching records in the output files.

Lets take the foll scenario:

Infile1 :
At positon 147-148 (binary)
10
10
10
10
10
20
30

Infile 2:
At positon 1-2 (binary)
10
25

The expected output files are:
OUTFILE1:
10
10
10
10
10

OUTFILE1:
20
30

The outfiles got with the following job are:
OUTFILE1:
10

OUTFILE2:
10
10
10
10
20
30

Below is the job i am currently using:

Frank Yaeger · Posted: Mon Sep 01, 2008 11:22 pm

Here's a DFSORT/ICETOOL job that will do what you asked for:

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

Thanks a lot Frank!!!!!! It was of great help.