# Multi-fetch settings ignored

**URL:** <https://techcommunity.softwareag.com/t/multi-fetch-settings-ignored/80710>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Linux, Natural-Database-Interfaces-on-Open-Systems\
**Created:** [April 15, 2009, 12:32am UTC](https://techcommunity.softwareag.com/t/multi-fetch-settings-ignored/80710 "2009-04-15T00:32:46Z")\
**Posts on this page:** 3\
**Page:** 1

<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:** [April 15, 2009, 12:32am UTC](https://techcommunity.softwareag.com/t/multi-fetch-settings-ignored/80710/1 "2009-04-15T00:32:46Z")

</div>

Windows XP; Natural 635; Adabas 614

In NATPARMs MFSET=ON, but when I RUN or EXecute the following program, Adabas does not return multiple records with each call.

```auto
DEFINE DATA LOCAL
1 EMP VIEW EMPLOYEES
  2 PERSONNEL-ID
  2 NAME
END-DEFINE
*
READ (80) MULTI-FETCH ON EMP BY PERSONNEL-ID
  DISPLAY *COUNTER
          PERSONNEL-ID
          NAME
END-READ
END
```

In the same Natural session, I run a similar program against another database/file and see 8 records returned per L3.

I am certain that at one time this particular program did invoke Multi-fetch. In my testing, I tried various combinations of MFSET, READ limit, and MULTI-FETCH, plus some changes to Adabas nucleus parameters.

What could I have done to have permanently turned off multi-fetch for this database and/or file?

---

<div class="post-metadata">

**Author:** ![Stephan\_Coslar](https://avatars.discourse-cdn.com/v4/letter/s/ce73a5/32.png) [@Stephan\_Coslar](https://techcommunity.softwareag.com/u/Stephan_Coslar)\
**Post date:** [April 15, 2009, 11:03am UTC](https://techcommunity.softwareag.com/t/multi-fetch-settings-ignored/80710/2 "2009-04-15T11:03:48Z")

</div>

Generally your settings are sufficient, even more than sufficient. Both, “MFSET=ON” and the statement based “MULTI-FETCH ON” should trigger the multi-fetch. Even “MFSET=OFF” and “MULTI-FETCH ON” would do so.

Is your Adabas database defined as “ADA” or as “ADA2” in your Natural configuration file? Only “ADA” would do multi-fetch.

---

<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/multi-fetch-settings-ignored/80710/3 "2021-04-02T14:51:47Z")

</div>