James Trudeau writes:

>>> James Trudeau <[log in to unmask]> 07/18/97 10:36am
>>>
Howdy,

OK so I have a problem record in a 1.5 million record dataset.  Using
QUERY I can filter to that specific record and the tell QUERY "numbers"
thereby giving that records specific relative record number or something
like it.  Problem is I can't figure out those numbers and as how this is
an undocumented feature there is no documentation (and no, I still
haven't found that CD).  So I quickly put a counter in the program
and upon arrival at the record_from_hell displayed the record count
from the DBGETS.  The specifics follow.

QUERY "numbers"                                64 3374
Blocking factor                                      18
Record count from application program 3130

So my question is how do I determine the number of DBGET mode 2
from QUERY "numbers" it will require to get to my area of interest.
-----------------------------------------------------------------------------------
The "NUMBERS" command in Query can be used after a find and shows
two numbers.  In the above example, "64" is the dataset number
corresponding to the MPE filename of root64.  The "3374" is not a relative
record number, but an absolute record number that can be used on a
DBGET mode 4 retrieval.  Your counter value of 3130 shows the number
or records found up to absolute record number 3374.  The difference of
244 are record number locations of deleted entries.

Mike Berkowitz
Guess? Inc.