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):||17 February 2010|
|PDF File Size:||6.28 Mb|
|ePub File Size:||19.96 Mb|
|Price:||Free* [*Free Regsitration Required]|
JCL – Basic Sort Tricks
Post as a guest Name. The F1 field is in positions of the joined record and the F2 field is in positions of the joined record, so each joined record is split into those two records and written to the BOTH file. For F1 records with a match in F2 for example, the F and F recordsthe indicator in position 35 has a ‘B’. zort
Thus, BOTH contains these records: I have a small question. Currently those are output as F2 appended to F1, and entire twice the size record written.
JOINKEYS application examples
Then you need to output the data. David F Frank F Sign up using Facebook.
It is certainly useful for testing, even if you don’t want it in the final code. It contains the following records: Sign up or log in Sign up using Google.
The REFORMAT statement defines the fields to be extracted for the joined records in the order in which they are to appear, and includes an indicator in the last position that will be set to ‘1’ if the key is found only in the F1 file, ‘2’ if the key is found only in the Jonikeys file, or ‘B’ if the key is found in the F1 file and in the F2 file. For F1 records without a match in F2 for example, the F recordthe indicator in position 35 has a ‘1’.
Example 5 – Paired and unpaired F1/F2 records (indicator method)
Email Required, but never shown. The assumption is that joinkeyys data is in key order already. It will contain the unpaired F2 records as follows: These are the F1 records without a match in F2. Can i do it using Joinkeys, if yes, How? I’ll assume you want the data in separate places: These are the F1 and F2 records with a match. These are the F2 records without a match in F1.
It will joinkeya the unpaired F1 records as follows: The shorter F1 record is padded with blanks on the right to the length of the F2 record. That is what the sorrt For F2 records without a match in F1 for example, the F recordthe indicator in position 35 has a ‘2’.
How can i get those update records? What is the key? It is not exactly clear what output you want here. Yes, thanks, I was just typing, not testing: Sort unmatched records using joinkeys Ask Question.