I know FIND NUMBER determines the no. of records matching WITH/WHERE criteria specified and doesn’t initiates any processing loop and no data fields from the database are available.
Seems FIND NUMBER…WITH combo gets *NUMBER value from Inverted List and doesn’t go through data storage and work. Let me know if this sounds ok.
However, FIND NUMBER…WITH…WHERE… combo issues S1+L1…+RC commands (as per my DBLOG) and seems go through data storage and work. An automatic internal processing loop is created to evaluate the where clause (and *COUNTER gets increased against it).
Who evaluates (ADABAS/NATURAL??) this WHERE and how?
Can you please explain why (pros of) this internal processing loop? (over a regular processing loop that a simple FIND initiates)
What could be the processing differences between:
FIND NUMBER does not result in the initiation of a processing loop and no data fields from the database are made available.