File Matching › Creating Unique Match-key Names › Demonstration

Demonstration

Objective

This example matches two files that are defined to the data dictionary. The match key for both files is PART-NUMBER. PART-NUMBER in the PARTS-INVENTORY file is assigned STOCK-REF-NUM as a unique name.

Procedure

• A DD= specification on the IN parameter provides alternative file assignments for each file.
• A REC parameter renames the PART-NUMBER field of the PARTS-INVENTORY file.
• An MK= specification of the new name of the PART-NUMBER (STOCK-REF-NUM) is the match key for the PARTS-INVENTORY file.

Partial Code

 col. 2
 ▼
 DATABASE DICTNAME=DOCUDICT
 IN 130 DD=SYSO11  FN=PARTS-INVENTORY  MK=STOCK-REF-NUM
*       WAREHOUSE-CODE  BIN-POINTER
 REC STOCK-REF-NUM  1  10

 IN 170 DD=SYS012  FN=PART-DESC  MK=PART-NUMBER  WAREHOUSE-ID
*       BIN-LOCATION