|
|
| Author |
Message |
anilaics
New User
Joined: 15 Feb 2006
Posts: 1
|
|
|
|
Please clarify below doubt in using sort utility
Input1
B052RRN.RASRSC.ASSOC11.EXT3
11aaaaaa111112
77gggggg777777
44dddddd444445
55eeeeee555555
22bbbbbb222223
66ffffff666666
88hhhhhh888888
33cccccc333333
Input2
B052RRN.RASRSC.ASSOC11.EXT2
11aaaaaa111111
77gggggg777777
44dddddd444444
55eeeeee555555
22bbbbbb222222
66ffffff666666
88hhhhhh888888
33cccccc333333
sort card used
JOINKEYS FILES=F1,FIELDS=(1,2,A,9,6,A)
JOINKEYS FILES=F2,FIELDS=(1,2,A,9,6,A)
JOIN UNPAIRED,F1,ONLY
REFORMAT FIELDS=(F1:9,6,F1:1,2)
SORT FIELDS=COPY
Output getting
11111211......
22222322......
44444544......
Expected output(what should be changed in sort card to get the below o/p)
Layout
1-6 bytes=fields mimatch from file
7-8 bytes=1st 2 bytes from file1
9-14bytes=fields from file2 having mismatch
11111211111111
22222322222222
44444544333333 |
|
| Back to top |
|
 |
References
|
|
 |
Skolusu
DFSORT Developer
Joined: 07 Dec 2007
Posts: 961
Location: San Jose
|
|
|
|
anilaics,
How do you link the mismatching keys ? Is there some other which you can use to match?
Also what is the LRECL and recfm of the files involved?
What is the position and format of the keys
Post all the rules involved |
|
| Back to top |
|
|
Terry Heinze
Senior Member
Joined: 14 Jul 2008
Posts: 1054
Location: Richfield, MN, USA
|
|
|
|
| Please use a meaningful Subject next time. |
|
| Back to top |
|
|
|
|
|
