Multi-fetch settings ignored

, , ,
1

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.

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?

2

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.