# sorting

**URL:** <https://techcommunity.softwareag.com/t/sorting/76533>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Mainframes\
**Created:** [April 10, 2008, 9:42am UTC](https://techcommunity.softwareag.com/t/sorting/76533 "2008-04-10T09:42:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![prakash3](https://avatars.discourse-cdn.com/v4/letter/p/9f8e36/32.png) [@prakash3](https://techcommunity.softwareag.com/u/prakash3)\
**Post date:** [April 10, 2008, 9:42am UTC](https://techcommunity.softwareag.com/t/sorting/76533/1 "2008-04-10T09:42:00Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [April 11, 2008, 9:04am UTC](https://techcommunity.softwareag.com/t/sorting/76533/2 "2008-04-11T09:04:55Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 2:49pm UTC](https://techcommunity.softwareag.com/t/sorting/76533/3 "2021-04-02T14:49:20Z")

</div>