STUTTGART DROSSELWEG 326A
STUTTGART MEISENGASSE 4711C
STUTTGART MEISENGASSE 0815
FRANKFURT ZUR FINKENWIESE 12
FRANKFURT ELSTERGASSE B52
HAMBURG ADLERHORST 23
BERLIN KOLIBRI HIN UND WEG
2. all adresses without valid city (not in second dataset)
BROWSE userid.FSS00050.ICESMPL.MATCH Line 0000000000 Col 001 080
Command ===> Scroll ===> CSR
********************************* Top of Data **********************************
BERLIN KOLIBRI HIN UND WEG
FRANKFURT ZUR FINKENWIESE 12
HAMBURG ADLERHORST 23
STUTTGART DROSSELWEG 326A
******************************** Bottom of Data ********************************
NotIn1:
Code:
BROWSE userid.FSS00050.ICESMPL.NOTIN1 Line 0000000000 Col 001 080
Command ===> Scroll ===> CSR
********************************* Top of Data **********************************
DORTMUND
******************************** Bottom of Data ********************************
NotIn2:
Code:
BROWSE userid.FSS00050.ICESMPL.NOTIN2 Line 0000000000 Col 001 080
Command ===> Scroll ===> CSR
********************************* Top of Data **********************************
MÃœNCHEN STARENSTRASSE 1234
TRIER BUSSARD STEIGE 49
******************************** Bottom of Data ********************************
Using the smart trick "Create files with matching and non-matching records " you can use the following DFSORT Joinkeys which would give you the results you need.
BERLIN KOLIBRI HIN UND WEG
FRANKFURT ZUR FINKENWIESE 12
FRANKFURT ELSTERGASSE B52
HAMBURG ADLERHORST 23
STUTTGART DROSSELWEG 326A
STUTTGART MEISENGASSE 4711C
STUTTGART MEISENGASSE 0815
However notice that the results are sorted on the key. If you need to retain the original order of the input dataset then you need to use the following Joinkeys job
STUTTGART DROSSELWEG 326A
STUTTGART MEISENGASSE 4711C
STUTTGART MEISENGASSE 0815
FRANKFURT ZUR FINKENWIESE 12
FRANKFURT ELSTERGASSE B52
HAMBURG ADLERHORST 23
BERLIN KOLIBRI HIN UND WEG
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum