# Where condition in FIND using ACB's or ACBX's

**URL:** <https://techcommunity.softwareag.com/t/where-condition-in-find-using-acbs-or-acbxs/80460>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Mainframes\
**Created:** [March 9, 2009, 10:47am UTC](https://techcommunity.softwareag.com/t/where-condition-in-find-using-acbs-or-acbxs/80460 "2009-03-09T10:47:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sriramp](https://avatars.discourse-cdn.com/v4/letter/s/bc79bd/32.png) [@sriramp](https://techcommunity.softwareag.com/u/sriramp)\
**Post date:** [March 9, 2009, 10:47am UTC](https://techcommunity.softwareag.com/t/where-condition-in-find-using-acbs-or-acbxs/80460/1 "2009-03-09T10:47:00Z")

</div>

Hi,

Is there any option of providing a “WHERE” condition when doing a S4 command using the direct call to ADABAS from a COBOL or a PL1 program.

Thanks in advance for your replies.

Regards,  
Sriram

---

<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:** [March 9, 2009, 12:05pm UTC](https://techcommunity.softwareag.com/t/where-condition-in-find-using-acbs-or-acbxs/80460/2 "2009-03-09T12:05:07Z")

</div>

No. The WHERE clause is a Natural construct, used to apply conditional logic to records returned from a database. Adabas direct commands have no facility to provide such conditional logic.

---

<div class="post-metadata">

**Author:** ![sriramp](https://avatars.discourse-cdn.com/v4/letter/s/bc79bd/32.png) [@sriramp](https://techcommunity.softwareag.com/u/sriramp)\
**Post date:** [March 9, 2009, 12:33pm UTC](https://techcommunity.softwareag.com/t/where-condition-in-find-using-acbs-or-acbxs/80460/3 "2009-03-09T12:33:54Z")

</div>

Thanks a lot for a quick reply.

---

<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:** [March 9, 2009, 11:09pm UTC](https://techcommunity.softwareag.com/t/where-condition-in-find-using-acbs-or-acbxs/80460/4 "2009-03-09T23:09:25Z")

</div>

You can use the non-descriptor search. If you include non-descriptor fields in the Search Buffer, Adabas will apply the search criteria to the records read.

This is not exactly a WHERE clause: if the element is a descriptor, the inverted lists will be used to identify the records to select; if it is not, the records will be read.

---

<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:51pm UTC](https://techcommunity.softwareag.com/t/where-condition-in-find-using-acbs-or-acbxs/80460/5 "2021-04-02T14:51:39Z")

</div>