Need unique records using sort or join



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Need unique records using sort or join

Postby srikanth_cool » Sun Nov 16, 2014 3:02 pm

Hi,
I have two input flat files(FB) with different record length. I need to get only the unique records from particular positions to 1st output file & non-unique records
to 2nd output file.

Input File 1:
100 123 AAA
200 234 BBB

Input File 2:
ABC ZZZ 100 QQQ AAA
ABC XXX 300 QQQ CCC

1st - Output file Need Output like below:
100 AAA
200 BBB
300 CCC

2nd - Output file Need Output like below:
100 AAA

How can we achieve the above result using sort. Please help

Thanks in Advance
srikanth_cool
 
Posts: 2
Joined: Sun Nov 16, 2014 11:36 am
Has thanked: 0 time
Been thanked: 0 time

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post