I´ve got two files, the first one is the master and the second is the conditioner.
File1
Code:
XX NI10000001A XXXXX XX NI40000007G XXXXX
XX NI10000002B XXXXX XX NI50000009I XXXXX
XX NI20000003C XXXXX XX NI20000004D XXXXX
XX NI20000004D XXXXX XX NI50000010J XXXXX
XX NI30000005E XXXXX XX NI10000001A XXXXX
XX NI30000006F XXXXX XX NI40000008H XXXXX
XX NI40000007G XXXXX XX NI30000005E XXXXX
Now, my problem appears when I´ve got dups in the conditioner file (file2). I don´t know how I can manage with this.
The new files are like this:
File1:
Code:
XX NI10000001A XXXXX XX NI40000007G XXXXX
XX NI10000002B XXXXX XX NI50000009I XXXXX
XX NI20000003C XXXXX XX NI20000004D XXXXX
XX NI20000004D XXXXX XX NI50000010J XXXXX
XX NI30000005E XXXXX XX NI10000001A XXXXX
XX NI30000006F XXXXX XX NI40000008H XXXXX
XX NI40000007G XXXXX XX NI30000005E XXXXX
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
Iratxe,
We can reduce the number of passes to get the desired results. Please answer the following questions
1. What is the LRECL and RECFM of both input and output files
2. What is the position, format and length of the key in both files
3. Can the key have duplicates in any of the files?
1. What is the LRECL and RECFM of both input and output files
LRECL=80 RECFM=FB
2. What is the position, format and length of the key in both files
Position=9 Format=CH Length=11
3. Can the key have duplicates in any of the files?
Only in the second one (File 2).