Q: I recently ran into a problem with the %LOOKUP function (both in free and in fixed format). A converted program (which had originally used the LOOKUP operation) was using %LOOKUP on an array that was set up as ASCENDING. When the lookup occurred, no element was found. When I removed the ASCENDING keyword, the lookup word fine. Any ideas?
A: Unlike the LOOKUP operation, the %LOOKUPxx functions perform a binary search if the array is sequenced. This greatly improves performance, by reducing the number of comparisons that the lookup function must make. But a binary search relies on the fact that the elements are in sequence; if the entries are not in sequence, %LOOKUP may not get a hit.
Runtime arrays are not sequence checked by the compiler, so it’s possible that the array was out of sequence despite ASCEND. The %LOOKUP function was depending upon ascending sequence, and gave up when it got to an element that was higher than the search argument. The problem can be solved by executing SORTA before the %LOOKUP, or by removing the ASCEND keyword.
ASCEND and DESCEND are only necessary when you are doing a high/low match compared to the search argument, and not for an equal match. For equal lookups ASCEND would not be necessary (or even desirable).