Matching 2 Files with ICETOOL



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

Matching 2 Files with ICETOOL

Postby dragone007 » Wed Jun 04, 2008 7:46 pm

Hello,

I'm a beginner in DFSORT. I want to match 2 Files and produce 3 Outputs.
1-st Output with all records matched between INPUT-1 and INPUT-2 including all duplicates.
2-nd Output with all non-matched records from INPUT-1 including all duplicates.
3-rd Output with all non-matched records from INPUT-2 including all duplicates.

Till now I've done only JCL-s to match files with no duplicates using ICETOOL.Can anyone help me out with this requirements ? Thanks a lot guys.

INPUT-1 (LRECL=80):
1111111111AAAAAAAAAAAAAAAAAA
1111111111BBBBBBBBBBBBBBBBBB
1111111111CCCCCCCCCCCCCCCCCC
2222222222DDDDDDDDDDDDDDDDDD
2222222222FFFFFFFFFFFFFFFFFF
3333333333HHHHHHHHHHHHHHHHHH
4444444444GGGGGGGGGGGGGGGGGG
6666666666IIIIIIIIIIIIIIIIII

INPUT-2 (LRECL=80):
1111111111AAAAAAAAAAAAAAAAAA
1111111111BBBBBBBBBBBBBBBBBB
4444444444CCCCCCCCCCCCCCCCCC
5555555555DDDDDDDDDDDDDDDDDD
5555555555EEEEEEEEEEEEEEEEEE


OUTPUT-1 - LRECL=80 (all matched records from INPUT-1 and INPUT-2):
1111111111AAAAAAAAAAAAAAAAAA
1111111111BBBBBBBBBBBBBBBBBB
1111111111CCCCCCCCCCCCCCCCCC
1111111111AAAAAAAAAAAAAAAAAA
1111111111BBBBBBBBBBBBBBBBBB
4444444444GGGGGGGGGGGGGGGGGG
4444444444CCCCCCCCCCCCCCCCCC

OUTPUT-2 - LRECL=80 (all non matched records from INPUT-1):
2222222222DDDDDDDDDDDDDDDDDD
2222222222FFFFFFFFFFFFFFFFFF
3333333333HHHHHHHHHHHHHHHHHH
6666666666IIIIIIIIIIIIIIIIII

OUTPUT-3 - LRECL=80 (all non matched records from INPUT-2):
5555555555DDDDDDDDDDDDDDDDDD
5555555555EEEEEEEEEEEEEEEEEE


Hope to have shown all the necessary information. Thanks again.

Best regards
dragone007
 
Posts: 3
Joined: Wed Jun 04, 2008 7:01 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Matching 2 Files with ICETOOL

 

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post