# deletion of duplicate records

**URL:** <https://techcommunity.softwareag.com/t/deletion-of-duplicate-records/57781>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Linux, Adabas-Utilities-on-Open-Systems\
**Created:** [September 16, 2005, 4:30pm UTC](https://techcommunity.softwareag.com/t/deletion-of-duplicate-records/57781 "2005-09-16T16:30:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sai](https://avatars.discourse-cdn.com/v4/letter/s/ecd19e/32.png) [@sai](https://techcommunity.softwareag.com/u/sai)\
**Post date:** [September 16, 2005, 4:30pm UTC](https://techcommunity.softwareag.com/t/deletion-of-duplicate-records/57781/1 "2005-09-16T16:30:46Z")

</div>

Can any one tell how to delete duplicate records from a databse file using the Adabas utilies.

---

<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:** [September 16, 2005, 5:40pm UTC](https://techcommunity.softwareag.com/t/deletion-of-duplicate-records/57781/2 "2005-09-16T17:40:25Z")

</div>

The only ones coming to my mind as being suitable for the task are

- ADAMUP  
ADATST

but you’d already have to know what records you are looking for, none of them will automagically delete duplicates out of a set.

Just wondering why you can’t write a NATURAL program or use other means (SQL Gateway, …) for that task ?

---

<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:38pm UTC](https://techcommunity.softwareag.com/t/deletion-of-duplicate-records/57781/3 "2021-04-02T14:38:52Z")

</div>