Gentlemen,
Thank you for your help. JOIN is the function I know less than other
features. Time to change it, since it is good thing.
I'll look at Smart DFSORT Tricks, especially I'm also author of one of
them. ;-)
(it was ~20 years ago, Frank Yeager asked me for that trick, nothing
big, just a trick)
Regards
--
Radoslaw Skorupka
Lodz, Poland
W dniu 23.07.2020 o 17:03, Sri h Kolusu pisze:
I see it is candidate for REXX script, but DFSORT job seems to be more
elegant.
Radoslaw Skorupka,
As Max already shown DFSORT does have an elegant file matching capability
using JOINKEYS. Please check the smart DFSORT trick "Create files with
matching and non-matching records" which is available at
https://www.ibm.com/support/pages/node/665475
If you want to do it DFSORT, I think you'll have to use ICETOOL with the
SPLICE option.
Joe,
SPLICE is an older technique and has limitations(many to many match),
using Joinkeys is the ideal solution for this case
You can use JOIN function of DFSORT:
Max,
Excellent !! Thank you.
Thanks,
Kolusu
DFSORT Development
IBM Corporation
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
.
======================================================================
Jeśli nie jesteś adresatem tej wiadomości:
- powiadom nas o tym w mailu zwrotnym (dziękujemy!),
- usuń trwale tę wiadomość (i wszystkie kopie, które wydrukowałeś lub zapisałeś
na dysku).
Wiadomość ta może zawierać chronione prawem informacje, które może wykorzystać
tylko adresat.Przypominamy, że każdy, kto rozpowszechnia (kopiuje, rozprowadza)
tę wiadomość lub podejmuje podobne działania, narusza prawo i może podlegać
karze.
mBank S.A. z siedzibą w Warszawie, ul. Senatorska 18, 00-950
Warszawa,www.mBank.pl, e-mail: [email protected]. Sąd Rejonowy dla m. st.
Warszawy XII Wydział Gospodarczy Krajowego Rejestru Sądowego, KRS 0000025237,
NIP: 526-021-50-88. Kapitał zakładowy (opłacony w całości) według stanu na
01.01.2020 r. wynosi 169.401.468 złotych.
If you are not the addressee of this message:
- let us know by replying to this e-mail (thank you!),
- delete this message permanently (including all the copies which you have
printed out or saved).
This message may contain legally protected information, which may be used
exclusively by the addressee.Please be reminded that anyone who disseminates
(copies, distributes) this message or takes any similar action, violates the
law and may be penalised.
mBank S.A. with its registered office in Warsaw, ul. Senatorska 18, 00-950
Warszawa,www.mBank.pl, e-mail: [email protected]. District Court for the Capital
City of Warsaw, 12th Commercial Division of the National Court Register, KRS
0000025237, NIP: 526-021-50-88. Fully paid-up share capital amounting to PLN
169.401.468 as at 1 January 2020.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
