# Reading adabas file through more than one key

**URL:** <https://techcommunity.softwareag.com/t/reading-adabas-file-through-more-than-one-key/173218>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Performance\
**Created:** [November 4, 2013, 10:10am UTC](https://techcommunity.softwareag.com/t/reading-adabas-file-through-more-than-one-key/173218 "2013-11-04T10:10:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Maitree\_Mishra](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@Maitree\_Mishra](https://techcommunity.softwareag.com/u/Maitree_Mishra)\
**Post date:** [November 4, 2013, 10:10am UTC](https://techcommunity.softwareag.com/t/reading-adabas-file-through-more-than-one-key/173218/1 "2013-11-04T10:10:47Z")

</div>

Hi All,

I have a file and have some keys for this file .

For example,

keys are A, B , C, D

I want to read the file through all these different different keys. I need a filtered result.

Can someone help me to know the best way to do so pleaseeeeeeee…

---

<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:** [November 4, 2013, 12:34pm UTC](https://techcommunity.softwareag.com/t/reading-adabas-file-through-more-than-one-key/173218/2 "2013-11-04T12:34:22Z")

</div>

You have four descriptor fields, A, B, C, D.

Does four READ LOGICAL loops not meet your requirement?

What exactly does " I need a filtered result. " mean to you?

---

<div class="post-metadata">

**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\
**Post date:** [November 5, 2013, 3:15pm UTC](https://techcommunity.softwareag.com/t/reading-adabas-file-through-more-than-one-key/173218/3 "2013-11-05T15:15:24Z")

</div>

maybe FIND is the command you need…

[http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat6314win/sm/find.htm#Search\_Criterion\_Adabas\_basic](http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat6314win/sm/find.htm#Search_Criterion_Adabas_basic)

---

<div class="post-metadata">

**Author:** ![Maitree\_Mishra](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@Maitree\_Mishra](https://techcommunity.softwareag.com/u/Maitree_Mishra)\
**Post date:** [November 10, 2013, 3:33pm UTC](https://techcommunity.softwareag.com/t/reading-adabas-file-through-more-than-one-key/173218/4 "2013-11-10T15:33:24Z")

</div>

Hi Matthias,

Thanks a lottt… I got the nested find statement from the link that you gave and this is what I needed… Thanks a lot… 🙂

---

<div class="post-metadata">

**Author:** ![Brian\_Johnson1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/brian_johnson1/32/163_2.png) [@Brian\_Johnson1](https://techcommunity.softwareag.com/u/Brian_Johnson1)\
**Post date:** [November 15, 2013, 6:34pm UTC](https://techcommunity.softwareag.com/t/reading-adabas-file-through-more-than-one-key/173218/5 "2013-11-15T18:34:46Z")

</div>

Best you share your code with the DBA though to tune this. FIND statements are most like SQL in their power. You’ll get what you need, but sometimes at great cost to the database.

---

<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:29pm UTC](https://techcommunity.softwareag.com/t/reading-adabas-file-through-more-than-one-key/173218/6 "2021-04-02T15:29:45Z")

</div>


