# Find Command

**URL:** <https://techcommunity.softwareag.com/t/find-command/199595>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Basics-on-Mainframes\
**Created:** [June 8, 2018, 12:32pm UTC](https://techcommunity.softwareag.com/t/find-command/199595 "2018-06-08T12:32:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Selvaraj\_Natarajan](https://avatars.discourse-cdn.com/v4/letter/s/258eb7/32.png) [@Selvaraj\_Natarajan](https://techcommunity.softwareag.com/u/Selvaraj_Natarajan)\
**Post date:** [June 8, 2018, 12:32pm UTC](https://techcommunity.softwareag.com/t/find-command/199595/1 "2018-06-08T12:32:38Z")

</div>

I am trying to access Adabas database file using Natural program. I am using FIND command to fetch the records from Adabas DB using the descriptor (key). When I am doing so, I can see same data fetched more than 1 time. I want to know the reason,

1. why same data is fetched multiple times, when the table cannot have duplicate values.
2. How do we overcome this issue.

Thanks.

---

<div class="post-metadata">

**Author:** ![Steve\_Robinson](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/steve_robinson/32/107_2.png) [@Steve\_Robinson](https://techcommunity.softwareag.com/u/Steve_Robinson)\
**Post date:** [June 8, 2018, 1:41pm UTC](https://techcommunity.softwareag.com/t/find-command/199595/2 "2018-06-08T13:41:58Z")

</div>

You do not seem to understand Adabas at all.

All fields, including descriptors, can have duplicate values.

For example; surname could be a descriptor field, and there might be multiple records with the surname Natarajan.

There is an option to specify a descriptor field has unique values, but that is something usually done by a DBA, not a programmer.

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [June 8, 2018, 7:14pm UTC](https://techcommunity.softwareag.com/t/find-command/199595/3 "2018-06-08T19:14:36Z")

</div>

When reporting the records, include the ISN field. Each ISN represents a unique record.

```auto
FIND file WITH descriptor = value
  DISPLAY *ISN descriptor
```

If the ISNs are different, then you were mistaken in thinking the descriptor values are unique (“the table cannot have duplicate values”). If the ISNs are duplicated, then a descriptor component is from a multiple-occurring field, and the same record is being returned multiple times.

---

<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, 3:40pm UTC](https://techcommunity.softwareag.com/t/find-command/199595/4 "2021-04-02T15:40:49Z")

</div>