sorting

, ,
1

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:

DOB:

Designation:

Address:

File 2: Data file

Lrecl: 80

Employee ID:

Department Code:

Department Name:

Salary:

Current Status:

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

Lrecl: 80

First Name

Salary

Employee ID

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

2

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.