|
|
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 |
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.
The existing FIND command already covered this functionality by the sample that was given here.