Skip to Main Content
Due to the recent acquisition by IBM, the Adabas & Natural Ideas Portal does not contain ideas from products ApplinX and EntireX any longer. Please refer to the IBM Ideas Portal for these products from now on (IBMid required). Existing content will be migrated during the next few weeks.
Status Not in Plan
Workspace Natural for z/OS
Categories Natural (NAT)
Created by Guest
Created on Jul 15, 2021

FIND NUMBER RECORDS ...

Background:
Currently, Natural has no "generic" way to find the number of records loaded in an Adabas file. Natural must always use the name of a file-specific descriptor which is "known to be populated for every record".
e.g. FIND NUMBER EMPLOYESS WITH PERSONNEL-ID > 0

However, it would be better if there was a more generic syntax which was independent of any file-specific descriptors.
Examples:
e.g. FIND NUMBER EMPLOYEES WITH ISN > 0 /* syntax like this?
or FIND NUMBER RECORDS IN EMPLOYEES /* or like this?
DISPLAY *NUMBER
END

Enhancement Request:
Please provide a "generic syntax" for Natural to find the number of records loaded in an Adabas file.


Created on Brainstorm 12/06/2017 21:46
Brainstorm ID 5514
  • Lewis Pritchard
    Jun 5, 2025

    Which specific example does this response refer to? The original one using PERSONNEL-ID works, but can produce a ridiculously long response time or even an error for a large file. Of course, it also requires a key that returns the entire file, which won't always be available.

    The two suggestions quoted don't work (of course).

    Does Adabas keep track of the "RECORDS LOADED" value that's shown in the ADAREP report, or are they actually counted in order to produce the report? The ability to query the total records, without tediously counting them, could be quite useful.

  • Admin
    Eli Cohen
    Sep 9, 2021

    The existing FIND command already covered this functionality by the sample that was given here.

  • +2