there are 2 input files employee, data file and the output will go the out file on sorting basis

File 1: Employee File

Lrecl: 100

First Name:

Last Name:

Employee ID:




File 2: Data file

Lrecl: 80

Employee ID:

Department Code:

Department Name:


Current Status:

File3: (Out-put file) Sorted on Employee ID

Lrecl: 80

First Name


Employee ID

i want to know where the intermediate result will be stored and how it will sort.

depends on your Natural parameters and if you are running it in CICS, batch, TSO, wherever. The “intermediate file” can be in-memory or it can use external sort utilities (such as SYNCSORT) and whatever that sort utility uses for memory and/or intermediate files.