Both Files Matching Records (Inner Join) Write only records that match on key from both files. //STEP01 EXEC PGM=SORT //SYSPRINT DD. It is a simple JOINKEYS: OPTION COPY JOINKEYS F1=INA,FIELDS=(4,80), SORTED,NOSEQCK JOINKEYS F2=INB,FIELDS=(4,80),SORTED,NOSEQCK JOIN. It is a simple JOINKEYS: OPTION COPY JOINKEYS F1=INA,FIELDS=(4,80), SORTED,NOSEQCK JOINKEYS F2=INB,FIELDS=(4,80),SORTED.
|Published (Last):||18 August 2016|
|PDF File Size:||15.9 Mb|
|ePub File Size:||17.57 Mb|
|Price:||Free* [*Free Regsitration Required]|
Email Required, but never shown.
It will contain the unpaired F1 records as follows: These are the F1 and F2 records with a match. Sign up using Email and Password. It is not exactly clear what output you want here.
I have a small question. How can i get those update records? I’ll assume you want the data in separate places: It will contain the unpaired F2 records as follows: It is certainly useful for testing, even if you don’t want it in the final code. Then you need to output the data. For F2 records without a match in F1 for example, the F recordthe indicator in position 35 has a ‘2’. OUTFILs “run” concurrently as in the same record is presented to each in turn, then the next record, etc.
It will contain the paired F1 and F2 records as follows: Sign up using Facebook. Can i do it using Joinkeys, if yes, How?
IBM MAINFRAME & MVS FORUM
JCL Basic Sort Tricks
Joined Record Positions Extracted from F1 positions F2 positions 35 Indicator of where key was found. Thus, BOTH soort these records: Post as a guest Name.
These are the F1 records without a match in F2.