JOIN FIles

ICETOOL : Matching records from different data sets

ICETOOL is a batch front-end utility that uses the capabilities of DFSORT toperform the operations you request. Input and output…

6 years ago

Fill Method: Paired and unpaired records

Fill Method Paired and unpaired records - This example illustrates an alternative way to create three output files; paired F1/F2…

6 years ago

Indicator method: Paired and unpaired records

Indicator method: Paired and unpaired records - This example illustrates how you can create three output files; paired F1/F2 records,…

6 years ago

Unpaired records F2 using SORT Utility

Unpaired records F2: This example illustrates how you can select only unpaired records from one of two files. In this…

6 years ago

Paired records F1 using SORT

Paired records F1 - Below example illustrates how you can select only paired records from one of two files. In…

6 years ago

Paired records with duplicates using SORT

Paired records with duplicates: This example illustrates how you can join paired records from two files, both of which have…

6 years ago

Paired records without duplicates using SORT

Paired records without duplicates - ASA (formerly ANSI)control characters appear in Position 5 for variable-length records (just after the Record…

6 years ago

JOINKEYS joining two files using SORT

JOINKEYS feature joins transactions/records from two different files based on certain keys (i.e. fields with common information). The SORTJNF1 and…

6 years ago