Sort 2 IP files to 2 OP files based on matching conditions



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

Sort 2 IP files to 2 OP files based on matching conditions

Postby kovvurireddy » Tue Apr 25, 2017 8:23 pm

Hi Guys, I need your expert help with the very typical need below.
Requirement:
I have 2 input data sets of 80 bite long with several fields. Move record from i/p data set 2 based on matching FIELD1 in both data sets and only if FIELD2 in i/p data set 1.
In i/p data set 2 values of field to are always same as shown. In i/p data set 1 we should look for only AA or CC or both in order to move the record from i/p data set 2.
All data sets below of same fixed record length say 80 with fields shown below.



SORTIN1
FIELD-1        FIELD-2
11111           AA
11111           CC
22222           CC
33333           BB
44444           BB
55555           CC
66666           BB


SORTIN2
11111           FF
55555           FF
66666           FF
77777           FF


RESULTS
SORTOUT1
11111           AA
11111           CC
11111           FF
22222           CC
33333           BB
44444           BB
55555           CC
55555           FF
66666           BB



SORTOUT2
66666           FF
77777           FF


Edited to remove green colour of the font and use the code tags. Incorrect usage of the word "file" replaced by "data set". Other typos fixed.
kovvurireddy
 
Posts: 1
Joined: Tue Apr 25, 2017 7:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sort 2 IP files to 2 OP files based on matching conditions

 

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post