The JOINKEYS File Match utility help in comparing two files. JOINKEYS File Match operation is controlled by JOINKEYS, JOIN, and REFORMAT control statements. The SORTJNF1 and SORTJNF2, are the DD statements used to specify the files which will be used to perform the join operations. During JOIN operation on two files, each record from the […]
JOINKEYS File Match and Comparison Read More »
ICETOOL is a batch front-end utility that uses the capabilities of DFSORT toperform the operations you request. Input and output datasets can be defined using user-defined DD names. The file operations are specified in the TOOLIN DD statement. Additional conditions can be specified in user-defined ‘CTL’ DD statements. A few of the utilities of ICETOOL
ICETOOL : Matching records from different data sets Read More »
Fill Method Paired and unpaired records – This example illustrates an alternative way to create three output files; paired F1/F2 records, unpaired F1 records, and unpaired F2 records. It produces the same output as Example 5. Whereas Example 5 uses an indicator in one position to determine where the key was found, Example 6 uses
Fill Method: Paired and unpaired records Read More »
Indicator method: Paired and unpaired records – This example illustrates how you can create three output files; paired F1/F2 records, unpaired F1 records, and unpaired F2 records. In this case: F1 records which do not have a match in F2 on the specified keys (for example, key=David) will be written to the F1ONLY output file.
Indicator method: Paired and unpaired records Read More »
Unpaired records F2: This example illustrates how you can select only unpaired records from one of two files. In this case, we will select the F2 records that do not have a match in F1 on the specified keys (for example, key1=Molly and key2=2100). We will also omit certain records from each input file and
Unpaired records F2 using SORT Utility Read More »
Paired records F1 – Below example illustrates how you can select only paired records from one of two files. In this case, we will select the F1 records that have a match in F2 on the specified keys (for example, key1=Development and key2=Master). The F1 records are in comma-delimited form so we will parse them
Paired records F1 using SORT Read More »
Paired records with duplicates: This example illustrates how you can join paired records from two files, both of which have duplicate records. The result will be a cartesian join. The paired records are the records in F1 and F2 with matching keys (for example, key=Cats). Paired records with duplicates Example //SEP002 EXEC PGM=SORT //SYSOUT DD
Paired records with duplicates using SORT Read More »
Paired records without duplicates – ASA (formerly ANSI)control characters appear in Position 5 for variable-length records (just after the Record Descriptor Word (RDW)). So coding REMOVECC on the OUTFIL statement suppresses the control characters. This example illustrates how you can join paired records from two files using multiple keys. In this case, neither file has
Paired records without duplicates using SORT Read More »
JOINKEYS feature joins transactions/records from two different files based on certain keys (i.e. fields with common information). The SORTJNF1 and SORTJNF2 DD statements were used to specify these files. Each JOINKEYS statement must specify the DDNAME of the file it applies to and the starting position, length, and sequence of the keys in that file. You
JOINKEYS joining two files using SORT Read More »
