Help required in SORTJOIN/DFSORT



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

Help required in SORTJOIN/DFSORT

Postby sruthign19 » Wed Jan 08, 2014 10:02 pm

Hi
Please help me on the following...
1. Consider two files F1 and F2 both are of same format
my requirement is to SORTJOIN both the files on two fields,
on matching, records from both the files should be written to the output
else records from F1 to be written to the output.
My keys are
SORTJOIN KEYS F1=( 61,13,A,15,4,A)
SORTJOIN KEYS F2=( 02,13,A,15,4,A)

How would the sort card be?

TIA
sruthign19
 
Posts: 1
Joined: Wed Dec 04, 2013 7:20 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Help required in SORTJOIN/DFSORT

Postby rockstar2020 » Thu Jan 09, 2014 1:55 pm

Please go through the link below on JOINKEYS.
http://publibz.boulder.ibm.com/cgi-bin/ ... E1CA60/4.0
rockstar2020
 
Posts: 32
Joined: Wed Jan 08, 2014 3:51 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post